SELECT * FROM table WHERE id = #ID#
or more correctly
SELECT * FROM table WHERE id = #URL.ID#
~JustinMacCarthy
----- Original Message -----
From: WL <[EMAIL PROTECTED]>
To: Cold Fusion Talk <[EMAIL PROTECTED]>
Sent: Tuesday, June 20, 2000 12:09 PM
Subject: Parsing variables?
> [nb: beginners' question. Hope you all don't mind]
>
> Hi.
>
> I've dealt with PHP for some time and am moving into CF at the moment.
> Could someone explain how I parse data and variables in CF? I have a
number
> of SQL statements which generate an ID to be used in another SQL statement
> on another page, as follows:
>
> <cfoutput query ="ad">
> <a href="show.cfm?method=show&ID=#ID#">
> #subject#
> </a><br>
> </cfoutput>
>
> In show.cfm, what should the WHERE part of the Sql look like?
>
> Thanks for any help.
>
> Will
>
> --------------------------------------------------------------------------
----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
>
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
