MySQL / Inverted Commas / Dreamweaver Ultradev

[abooth]

Hi, just a newbie to mysql, and the like, installed it on my Cobalt RaQ4 yesterday, now trying to use ChilliASP, MySQL, and Macromedia DreamWeaver Ultradev to have a play.

http://www.vite-gites.com/asp/

is where I have put the basic script (that lists all data)

http://www.vite-gites.com/asp/form.asp allows you to add entries and search, the add entries works fine, but for the search, unless you place the string in the box in inverted commas, it doesn't work, it looks for another column with the name you use, and the same for the detail, the links that are placed there don't work, but if you put the data in inverted commas, it works fine.

Has anyone seen this before, or is there a simple solution to it?

Hope you can help!

Cheers

Adam

[jonirvine]

Hi,

I know nothing of MySql, so I may be wrong, but I know a little ASP (VBscript)

Could you not include the inverted comma's within the value of the text boxes on submission?

eg: When it processes the value, it adds the " and " before it searches?

Probably not, but worth a shot?

jon

[abooth]

Thats what I have done; it's just irritating to have to modify every ASP script that Dreamweaver comes up with!

Adam