Andy Mid.

My brother is just starting to write a web site using MYSQL for the first time and he's after some advice on a couple of problems that he has (regarding writing to a MYSQL database using ASP).


He's tried asking on a proper IT help forum but isn't getting too far so I thought I'd ask on scoobynet as I'm always amazed by how much help can be found here

anyway, the problems are....

1) When I try to write to a field, I sometimes get the error: "Microsoft Cursor Engine (0x80040E21)
Multiple-step operation generated errors. Check each status value."

This error appears when the entered data is over a certain length (not the same each time!!! - normally over 10 - 15 characters).
The field itself has 200 character length.

2) I can read all the fields except for the primary key ("ID"). For example, if I try
myvar = objRS("ID")
response.write myvar
I get "Microsoft VBScript runtime (0x800A01CA)
Variable uses an Automation type not supported in VBScript"

any help mucho appreciated - thanks.

[Edited by Andy Mid. - 2/20/2003 10:45:13 PM]

Andy Mid.

If nobody can help, maybe someone can recommend good sites for getting MYSQL tips/advice ?

GaryK

Andy,

As regards the first problem, not sure until I see your ADO connection code, where is your cursor client or server side?

For the second one sounds like a type issue, I have heard of issues regarding oracle int. fields, perhaps do a search on www.deja.com???

(Edited cos Id put something stupid in)

Cheers

Gary

[Edited by GaryK - 2/21/2003 11:58:13 AM]

Andy Mid.

Thanks Gary - there has been a bit of progress on the original experts-exchange thread (linked above) but not everything is solved.

I'd try and contribute but I understand less than 5% of what is mentioned - lol