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 that mySQL can eat any quotes on any place,
But this comes from the past, and it is always good idea follow to standard.
> This also could be done with in-line variables or
> fields contents, but a little trickier.
>
> put "SELECT" && fld "fieldlist" && "FROM" && "'"
> & label of btn "tableSelect" & "'"\
> && "ORDER BY" && "'" & (label of btn
> "tableORderby") & "'" & "DESC" into tSQL
--
Best regards,
Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc
Valentina - Joining Worlds of Information
http://www.paradigmasoft.com
[I feel the need: the need for speed]
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
