Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - can’t see whats wrong with this code..
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Topic Closedcan’t see whats wrong with this code..

 Post Reply Post Reply
Author
dj air View Drop Down
Senior Member
Senior Member
Avatar

Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
Direct Link To This Post Topic: can’t see whats wrong with this code..
    Posted: 16 April 2003 at 12:24pm

hi guys, ive got a script(below) that updates the listings images and then the channel images and finally deletes the image details from the pictures table..... here is the code...

 

strFile = request.Querystring("File")

strSQL = "UPDATE tblListings SET "
strSQL = strSQL & "tblListings.Image =xxxxxx "
strSQL = strSQL & "WHERE tblListings.Image =" & strFile & " "
 
 
 'Write to the database
 adoCon.Execute(strSQL)

strSQL = "UPDATE tblChannel SET "
strSQL = strSQL & "tblChannel.Channel_Image=xxxxxx "
strSQL = strSQL & "WHERE tblChannel.Channel_Image = '" & strFile & "';"
       
 'Write to the database
 adoCon.Execute(strSQL)


 'Delete the topic from the database 
 'Initalise the strSQL variable with an SQL statement to get the topic from the database
 strSQL = "DELETE FROM PICTURES WHERE PICTURES.PIC_IMAGE =" & strFile
   
 'Delete the message from the database
 adoCon.Execute(strSQL)

here is the error message im getting

Microsoft OLE DB Provider for ODBC Drivers error '80040e10'

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.

/ASP/applications/Tv_guide/sample/tv/admin/Pic_delete.asp, line 23

ive spent hours on this code and can't see whats wrong can anyone help me with this problem...

thanx in advanced

Back to Top
dj air View Drop Down
Senior Member
Senior Member
Avatar

Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
Direct Link To This Post Posted: 16 April 2003 at 2:04pm
dont worry... fixed it... ussal thing go and have a drink and come back and see what was wrong....
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
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.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.