Error: Too few Parameters

Post Reply

Page <123 >

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
zaboss Members Profile Find Members Posts Senior Member Joined: 20 August 2002 Location: Romania Status: Offline Points: 454	Post Options Post Reply Quote zaboss Report Post Thanks(0) Quote Reply Posted: 02 March 2003 at 11:47am
	Well, no, they are both text fields.
	Cristian Banu Soft 4 web

michael Members Profile Find Members Posts Senior Member Joined: 08 April 2002 Location: United States Status: Offline Points: 4670	Post Options Post Reply Quote michael Report Post Thanks(0) Quote Reply Posted: 02 March 2003 at 12:20pm
	Well then they both need to be in single quotes like: sql = "Select * FROM Articles Where Art_Section.Articles = '" & RS1("Art_Section") & "' AND Issue_Nr='" & RS0("Cur_Issue") & "'"

zaboss Members Profile Find Members Posts Senior Member Joined: 20 August 2002 Location: Romania Status: Offline Points: 454	Post Options Post Reply Quote zaboss Report Post Thanks(0) Quote Reply Posted: 02 March 2003 at 12:32pm
	Nope! The same error! Too few Parameters. Expected 1. Even puted in session variable still trigers the error. I realy don't get it! Edited by zaboss
	Cristian Banu Soft 4 web

michael Members Profile Find Members Posts Senior Member Joined: 08 April 2002 Location: United States Status: Offline Points: 4670	Post Options Post Reply Quote michael Report Post Thanks(0) Quote Reply Posted: 02 March 2003 at 1:15pm
	Well there is some bug in your code that I just might be overlooking but the way you do it is just odd. Now, instead of executing the query do a resoponse.write sql and post the result here.

zaboss Members Profile Find Members Posts Senior Member Joined: 20 August 2002 Location: Romania Status: Offline Points: 454	Post Options Post Reply Quote zaboss Report Post Thanks(0) Quote Reply Posted: 02 March 2003 at 1:32pm
	When Response.Write, the error is: Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
	Cristian Banu Soft 4 web

michael Members Profile Find Members Posts Senior Member Joined: 08 April 2002 Location: United States Status: Offline Points: 4670	Post Options Post Reply Quote michael Report Post Thanks(0) Quote Reply Posted: 02 March 2003 at 2:35pm
	huh? I want you to just write the variable sql right before you execute it. Comment the execute statement out...... if there is something else bugging your script do an 'On Error Resume Next' on top of the page.

Bunce Members Profile Find Members Posts Senior Member Joined: 10 April 2002 Location: Australia Status: Offline Points: 846	Post Options Post Reply Quote Bunce Report Post Thanks(0) Quote Reply Posted: 02 March 2003 at 4:55pm
	RESPONSE.WRITE(sql) RESPONSE.END
	There have been many, many posts made throughout the world... This was one of them.

zaboss Members Profile Find Members Posts Senior Member Joined: 20 August 2002 Location: Romania Status: Offline Points: 454	Post Options Post Reply Quote zaboss Report Post Thanks(0) Quote Reply Posted: 03 March 2003 at 3:59am
	This is exactly what I did (response.write(sql)) and the error I got was "Arguments Are of Wrong Type...." I ggogle it and found a pretty detaliated explanation of the error, but I'm afraid it's a lilltle bit over my head!
	Cristian Banu Soft 4 web

Post Reply	Page <123 >

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.