Re: Error in script
Re: Error in script
- Subject: Re: Error in script
- From: Björn Lundin <email@hidden>
- Date: Thu, 25 May 2006 11:24:54 +0200
25 maj 2006 kl. 11.11 skrev David Bradley: Applescript Error:
MacSQL3 got an error: ct_send failed
set QueryText to "SELECT catPage FROM Products_T ORDER BY catPage DESC;" tell front document of application "MacSQL3" set rsPages to do query QueryText results as none
<cut>
set QueryText to "SELECT * FROM Products_T WHERE catPage = " & PageNo tell front document of application "MacSQL3" set rsProducts to do query QueryText results as none (Error on this line)
<cut> Not knowing too much of applescript, and even less of MacSQL3, it looks strange( to me) that one sql statement is ';' terminated, and the other is not
Also PageNo, it does have a value? Or else it is not valid SQL.
/Björn
Björn Lundin bnl at spray dot se
|
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden