Thanks, sweetie, I will as soon as I can get Word to stop blowing up on
me!<g>
I MAY have narrowed it down? I've literally torn it down to "Select * from
Referrals" and started rebuilding one element at a time to see what it
doesn't like and it appears it doesn't like the Boolean field. So I might be
doing it wrong? But I've tried without quotes and with single quotes...but
it keeps telling me that one item doesn't have a value. Since the error
happens when I add the Boolean statement, that must be it.
It doesn't seem to like either of these True statements?
gstrSQLQuery = _
"SELECT * FROM Referrals WHERE Referrals.TellerID = " _
& Chr(34) & strSingleTeller & Chr(34) & " AND " _
& "Referrals.Sales = True"
gstrSQLQuery = _
"SELECT * FROM Referrals WHERE Referrals.TellerID = " _
& Chr(34) & strSingleTeller & Chr(34) & " AND " _
& "Referrals.Sales = 'True'"
Dian ~
-----Original Message-----
From: Ray at home [mailto:[EMAIL PROTECTED]
Sent: Friday, December 10, 2004 9:57 PM
To: [EMAIL PROTECTED]
Subject: RE: [ASP] Help deciphering SQL error
Can you post the result of:
RESPONSE.WRITE yourSQLvariable
RESPONSE.END
Ray at home
> -----Original Message-----
> From: Dian D. Chapman [mailto:[EMAIL PROTECTED]
> <sigh> Yes, I'm STILL fighting this.
>
> I'm about to pick this query from hell apart, but can anyone
> tell me what this error means, literally. I mean, is it
> telling me that maybe a var is empty or what? Any ideas?
>
> Error upon SQL query attempt: "No value given for one or more
> parameters."
---------------------------------------------------------------------
Home : http://groups.yahoo.com/group/active-server-pages
---------------------------------------------------------------------
Post : [EMAIL PROTECTED]
Subscribe : [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
---------------------------------------------------------------------
Yahoo! Groups Links
--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.289 / Virus Database: 265.4.8 - Release Date: 12/8/2004
--
This email scanned and certified clean by AVG!
Checked by AVG Anti-Virus.
Version: 7.0.289 / Virus Database: 265.4.8 - Release Date: 12/8/2004
------------------------ Yahoo! Groups Sponsor --------------------~-->
$4.98 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/17folB/TM
--------------------------------------------------------------------~->
---------------------------------------------------------------------
Home : http://groups.yahoo.com/group/active-server-pages
---------------------------------------------------------------------
Post : [EMAIL PROTECTED]
Subscribe : [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
---------------------------------------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/active-server-pages/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
