Query Problem
Can someone tell my why I am getting this error. If I take the WHERE line out it returns all the data just fine Thanks Ron ODBC Error Code = 07001 (Wrong number of parameters) [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. Hint: The cause of this error is usually that your query contains a reference to a field which does not exist. You should verify that the fields included in your query exist and that you have specified their names correctly. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (2:1) to (5:70) in the template file e:\ns-server\docs\webapps\MFG\Probe\CardTrack\Card_Info\ParamOutput.cfm. cfquery name=pcards dbtype = dynamic ConnectString=DRIVER=Microsoft Access Driver (*.mdb); DBQ=\\bodata.micron.com\webapps\MFG\Probe\prbcardtrack\prbcards.mdb; SELECT Card_Type FROM tblCardData WHERE Card_Type=Parametric; /cfquery __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query Problem
Thanks it worked Getting up to early to see straight -Original Message- From: Paul Bowley [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 7:52 AM To: CF-Talk Subject: RE: Query Problem Try using single quotes around 'Parametric'. -Original Message- From: ronmyers [SMTP:[EMAIL PROTECTED]] Sent: 30 April 2002 14:41 To: CF-Talk Subject: Query Problem Can someone tell my why I am getting this error. If I take the WHERE line out it returns all the data just fine Thanks Ron ODBC Error Code = 07001 (Wrong number of parameters) [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. Hint: The cause of this error is usually that your query contains a reference to a field which does not exist. You should verify that the fields included in your query exist and that you have specified their names correctly. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (2:1) to (5:70) in the template file e:\ns-server\docs\webapps\MFG\Probe\CardTrack\Card_Info\ParamOutput.cfm. cfquery name=pcards dbtype = dynamic ConnectString=DRIVER=Microsoft Access Driver (*.mdb); DBQ=\\bodata.micron.com\webapps\MFG\Probe\prbcardtrack\prbcards.mdb; SELECT Card_Type FROM tblCardData WHERE Card_Type=Parametric; /cfquery __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Better Javascript/DHTML Calender!
I got it. Must of been the last one for the day to get it. If you want it let me know and I will email you a copy 30.4kb -Original Message- From: Kelly Matthews [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 9:44 AM To: CF-Talk Subject: RE: Better Javascript/DHTML Calender! it's down they have reached their max transfer load for the day, that's a free site for ya -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 11:39 AM To: CF-Talk Subject: RE: Better Javascript/DHTML Calender! That link doesn't work The site is down or doesn't exist -Original Message- From: Zac spitzer [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 9:18 AM To: CF-Talk Subject: Better Javascript/DHTML Calender! similair to Popup Calander XP or whatever, except it's free and not $150 US it's a cross browser, inline DHTML calender http://www.geocities.com/bazillyo/spiffy/calendar/ z __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
append Txt file to Access
Can some on tell me or point me in the right direction on how to append a comma delimited .txt file to an access database. The fist line of the file has the same header names as the database. Thanks Ron Just a beginner in Cold Fusion, But think its an awesome program ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: append Txt file to Access
I understand that. I was hoping I could do it through CF as the file changes and I wanted to use CFSchedule so it would update automatically -Original Message- From: Mark Smyth [mailto:[EMAIL PROTECTED]] Sent: Friday, December 14, 2001 7:53 AM To: CF-Talk Subject: RE: append Txt file to Access hi if you go to file - get external data - choose csv from the dropdown list and you should be away -Original Message- From: ronmyers [mailto:[EMAIL PROTECTED]] Sent: 14 December 2001 14:40 To: CF-Talk Subject: append Txt file to Access Can some on tell me or point me in the right direction on how to append a comma delimited .txt file to an access database. The fist line of the file has the same header names as the database. Thanks Ron Just a beginner in Cold Fusion, But think its an awesome program ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Url as Data Source
Is it possible to use a url as a datasource (newbie question) ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Opening a new Window
HI I am a newbie at Using CF and HTML in general, But I am having fun learning. My problem is I am opening a new window. I know how to set the size How do I set the location where it opens. Thanks Ron ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists