Okay...but the Chr(34) didn't cause a problem before. When it just said:
SELECT * FROM Referrals WHERE Referrals.TellerID = '444'
The report actually ran...FOR THE FIRST @#$%^%^ TIME IN 28 HRS!<g>
Then I added the Sales Referral = True stuff and it now blows up saying:
Run-time error '-2147217904(80040e10)':
No value given for one of more required parameters
Here is the SQL query that's being generated: (?????)
SELECT * FROM Referrals WHERE Referrals.TellerID = '444' AND Referrals.Sales
= True
Dian ~
-----Original Message-----
From: Shawn K. Hall [mailto:[EMAIL PROTECTED]
Sent: Friday, December 10, 2004 11:18 PM
To: [EMAIL PROTECTED]
Subject: RE: [ASP] Help deciphering SQL error
Hi Dian,
> ...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's not the True that's doing it, it's the Chr(34). Try replacing
it with a single apostrophe (Chr(39)).
And TRUE should not be in quotes or apostrophes in your SQL.
Regards,
Shawn K. Hall
http://ReliableAnswers.com/
'// ========================================================
Hope for the Best. Expect the worst. Life is a play. We're
unrehearsed.
-- Mel Brooks
---------------------------------------------------------------------
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/
