Jim,
thanks works great
Robert Mann
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Jim Ault
Sent: Sunday, October 01, 2006 10:43 AM
To: How to use Revolution
Subject: Re: sql update statement
put "'" into p -- < don't forget th
put "'" into p -- < don't forget this
get "2srd3 = " &p& fld 2srd3 &p
get it & ",2srd4 = " &p& fld 2srd4 &p
get it & ",2srd5 = " &p& fld 2srd5 &p
get it & ",2srd5 = " &p& fld 2srd5 &p
get it & ", srideht = " &p& fld srideht &p
get it & ", smisccomment = " &p& fld smisccomment &
d_id
= '" & fld "record_id" & "'" into tSQL
revExecuteSQL dbID2,tSQL
Robert Mann
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Jim Ault
Sent: Sunday, October 01, 2006 2:19 AM
To: How to use Revolution
Sub
e the [opt-j on the Mac] and build the string
> get "2srd3 =" & fld 2srd3
> get it & ",2srd4 =" & fld 2srd4
> get it & ",2srd5 =" & fld 2srd5
> get it & ",2srd5 =" & fld 2srd5
> get it & ", srideht ="
On 10/1/06 7:55 AM, "Stephen Barncard" <[EMAIL PROTECTED]>
wrote:
Hi Stephen,
> SELECT * FROM `Contractors` ORDER BY `id` DESC
^^^
Why you use here single quotes ?
SQL92 expect here double quotes.
Single quotes should be used for string constants only.
Yes I know t
lowing version of the above -
--temporarily use the [opt-j on the Mac] and build the string
get "2srd3 =" & fld 2srd3
get it & ",2srd4 =" & fld 2srd4
get it & ",2srd5 =" & fld 2srd5
get it & ",2srd5 =" & fld 2srd5
get it &
"tableORderby") & "'" & "DESC" into tSQL
by using groups, a handler could determine all
grouped field names (which are designed to match
the database fields), then create an array of all
the data in the fields.
This is pretty heady stuff, MYSQL, to get
I have a sql update statement that has several hundred items in it, is it
possible to leave it in list format like this
2srd3 = '"& fld "2srd3" &"',
2srd4 = '"& fld "2srd4" &"',
2srd5 = '"& fld "2srd5&
