I second that, however I would also add that it may pay to double check that
the DSN your passing is right when calling the tag. If you get this error
the DSN doesn't exist to the system.
-----Original Message-----
From: Mark Warrick [mailto:[EMAIL PROTECTED]]
Sent: Friday, 26 May 2000 7:40 AM
To: [EMAIL PROTECTED]
Subject: RE: Fusebox Methodology and #s?
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.
------------------------------------------------------------------------------
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.
