943,202 Members | Top Members by Rank

Ad:
  • ASP Discussion Thread
  • Unsolved
  • Views: 168
  • ASP RSS
Jul 11th, 2010
0

Script error in asp

Expand Post »
hello
I want to deleter record from my table in database but there is error which is Data type mismatch in criteria expression ,any one has any idea can tell me thank you.
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
aalqa is offline Offline
9 posts
since Jul 2010
Jul 12th, 2010
0
Re: Script error in asp
You should post the code for us to see, but I would guess that because you are deleting a row that is identified by ID that you may only have to change the parenthesis, so instead of using
ASP Syntax (Toggle Plain Text)
  1. where ID = "' & strID & '"
try using
ASP Syntax (Toggle Plain Text)
  1. where ID = ' & strID & '
Last edited by ArtistScope; Jul 12th, 2010 at 12:51 am.
Reputation Points: 5
Solved Threads: 14
Junior Poster
ArtistScope is offline Offline
146 posts
since Jun 2010
Jul 12th, 2010
0
Re: Script error in asp
Thank you , I get the solution and the solution is near to your solution
ASP Syntax (Toggle Plain Text)
  1. WHERE PatientId='" & pid & "'",conn
  2. %>
the solution was
ASP Syntax (Toggle Plain Text)
  1. "SELECT * FROM Patient WHERE PatientId=" & pid,conn
  2. %>
Last edited by aalqa; Jul 12th, 2010 at 4:25 am.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
aalqa is offline Offline
9 posts
since Jul 2010

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in ASP Forum Timeline: Simple associative array
Next Thread in ASP Forum Timeline: Steps for database connection usin ADO





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC