Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Updates of MySQL database fail using ADO / ASP
Thanks for the tips. I ended up using SQL commands to insert, update, delete etc. rows from the database. The "Query successful" messages I mentioned earlier disappeared after I removed some diagnostic code another programmer working on the project had inserted deep in the bowels of...- qmi
- Post #7
- Forum: Microsoft: ASP (Active Server Pages)
-
Invalid string or buffer length
Yes, I would like to see a sample piece of code. Also, could you let me know what ODBC settings you were using? -
TO_DAYS
The expression should be to_days(now())-60; and not to_days(now()-60); You want to convert today's date to an integer first and then subtract 60 off it, rather than attempting to subtract 60 off a date represented as a string and then trying to convert to an integer date. -
Invalid string or buffer length
I've also encountered the same problem using vbscript in an ASP application. Any update to the database via ADO, regardless of field type (eg. integer, string, etc.), fails. I would be interested to know if anyone has managed to get MySQL working with ADO. -
Updates of MySQL database fail using ADO / ASP
I checked all the datatypes and other table attributes such as 'required field?' and 'permit zero length string' etc. when I first received the error and it all looked OK. There should be no errors in that regard - the recordset is opened with an initial query that retrieves a row from the...- qmi
- Post #3
- Forum: Microsoft: ASP (Active Server Pages)
-
Syntax confusion by using the 'on'-clause
I struck the same problem. According to the documentation, the ON clause can only be used with a LEFT (outer) JOIN. From the MySQL documentation... ----------------------- MySQL supports the following JOIN syntaxes for use in SELECT statements: table_reference, table_reference... -
Updates of MySQL database fail using ADO / ASP
I've written an ASP application in VBScript that uses ADO to connect to, read from and update a MySQL database. The read (select) type queries work fine but any attempt to update a table fails with a variety of fairly generic error messages. eg. Microsoft OLE DB Provider for ODBC Drivers error...- qmi
- Thread
- Replies: 6
- Forum: Microsoft: ASP (Active Server Pages)
-
Can't update with ADO - MySQL / ADO / ASP
I've written an ASP application in VBScript that uses ADO to connect to, read from and update a MySQL database. The read (select) type queries work fine but any attempt to update a table fails with a variety of fairly generic error messages. eg. Microsoft OLE DB Provider for ODBC Drivers error...
