Well, going by standard CFML coding rules, if a variable name is contained
within quotes, then it needs to be wrapped in pound signs.
I find it hard to believe that your query ran fine without them, but who
knows, maybe you've got an ODBC datasource setup called "attributes.dsn" on
your server.
---mark
-------------------------
Mark Warrick
(714) 939-6431
The Sistonia Corporation
[EMAIL PROTECTED]
http://www.sistonia.com
-----Original Message-----
From: Lisa Greenberg [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 25, 2000 11:08 AM
To: cftalk
Subject: Fusebox Methodology and #s?
I'm studying the Fusebox methodology and am a bit confuse as
to why the # signs are necessary. In the example provide at
fusebox.org, for example, where the DSN is set in the
app_globals, I get a diagnostic error stating the odbc
source can't be located. If I follow the example:
<cfquery datasource="#attributes.DSN#" name"validateUser">
Select firstName, lastName, userID,userLevel From Users
where userName='#attributes.userName#' and
password='#attributes.password#' </cfquery>
If I remove the # signs the code runs smoothly. Please
explain.
Lisa
----------------------------------------------------------------------------
--
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.
