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

References:
	>Error in script (From: David Bradley <email@hidden>)

Prev by Date: Error in script
Next by Date: Re: Searching for cells/rows/columns in Excel
Previous by thread: Error in script
Next by thread: Exiting a repeat loop if not false
Index(es):
- Date
- Thread