Stored Procedures and Functions

2005-09-26 Thread Blue Wave Software
ntation or even better still a few Example scripts that I can pull apart and learn from. Regards, Justin Elward Blue Wave Software Pty Limited [EMAIL PROTECTED] Ph. +61 2 4320 6090 Fx.

Error in Update Command Text - What am I missing

2005-09-20 Thread Blue Wave Software
7; Error Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') WHERE CustID='MNO1234567890' AND UPDATED='2005-09-18 10:30:56'' at line 1 Tec Info: Server -> MySQL 4.1.11-nt-max vi

Partial Filtering

2005-08-18 Thread Blue Wave Software
I'm having one of those slow brain days. I want a partial filter egg. All records where field1 begins with "ABC" any body know the where clause to do this. In Access it's where field1 = 'ABC*' but I can't find the MYSQL equivalent, or isn't there one. Regards, Justin