SELECT @myvar := 1 ;
> -----Original Message----- > From: Gerald Norman [mailto:[EMAIL PROTECTED]] > Sent: Sunday, December 01, 2002 10:37 PM > To: [EMAIL PROTECTED] > Subject: Converting Access to MySQL > > > I have an application that currently is using an Access > database and am > in the process of converting over to MySQL. I downloaded the ODBC > driver and have been using ADO and have had no problems at all up to > this point. I have a number of parameterized SQL statements that > worked fine in Access, but aren't working at all with MySQL. I know > that MySQL supports variables in SQL statements using the @ prefix. > I've tried setting that as the prefix for the parameters but > it doesn't > work. I keep getting a 'unspecified error' when the SQL statement > executes. Am I missing something or does MySQL not support > parameters > that can be set at runtime? Thanks in advance for any assistance. > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php