MySQL Forums
Forum List  »  Microsoft Access

Ahh..you're not an ASP guy...sorry!
Posted by: Jim Rudnick
Date: August 03, 2004 01:48PM

Sorry Nick...I thought you were an ASP coder as well as an mySQL expert.

ASP does NOT require that you do an INSERT to place data in a dbase table, never did in fact.

Instead (and this was the original way they launched ASP with) you can simply call for a single record set...which I do with SELECT *

then use rs.AddNew and change any of those dbase table fields to new values and then do a simple rs.Update. This saves the new record as it's ownself...

Which is the way that I coded this simple asp page...you do NOT need to use INSERTS or any such other way.

And as you know, this works FINE if I use a 3 char name, but no more than 3.

The problem continues to still exist and I'm pretty frustrated by same....

Also I do not understand (my turn?) what you mean by "updating the table with a 5 letter name direclty from the mysql prompt.." either what you mean or how to try same???

Jim

Options: ReplyQuote


Subject
Views
Written By
Posted
4511
July 29, 2004 02:46PM
2709
July 29, 2004 03:39PM
2869
July 29, 2004 05:21PM
2530
July 30, 2004 12:40AM
2852
July 30, 2004 07:43AM
2525
July 30, 2004 08:11AM
2577
July 30, 2004 03:17PM
2548
July 31, 2004 02:06AM
2567
July 31, 2004 12:07PM
2636
August 01, 2004 09:12AM
2545
August 02, 2004 06:15PM
2551
August 03, 2004 01:49PM
Ahh..you're not an ASP guy...sorry!
2698
August 03, 2004 01:48PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.