ASP Programming
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsProgramming Languages - MoreASP Programming

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old November 19th, 2003, 01:20 AM
hamr2u hamr2u is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Nov 2003
Location: Phoenix
Posts: 2 hamr2u User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Send a message via AIM to hamr2u
Question Newbie question about URL Parameters

I'm new to ASP and programming in general so please be patient with me. My problem is: I've created an ASP/MS Access app with Dreamweaver. I have an admin page to edit/delete records. When I edit or delete a record, it works the first time and redirects me back to the main page. When I click on another record it adds the URL parameter to the end of the previous URL parameter and I get an error. Is there a simple piece of code to check the URL for the same parameter so that it will not just add it to the end. Following is and example (I need to remove first logId):

URL

Thanks!

Reply With Quote
  #2  
Old November 19th, 2003, 01:43 AM
fused fused is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: May 2003
Posts: 78 fused User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 6
What do you meant by "click on another record it adds the URL parameter to the end of the previous URL parameter and I get an error" ?

Regards the link you posted, why are there 2 instances of 'logId' ?

What's the error message you got?

Reply With Quote
  #3  
Old November 19th, 2003, 09:22 AM
hamr2u hamr2u is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Nov 2003
Location: Phoenix
Posts: 2 hamr2u User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Send a message via AIM to hamr2u
I'm sorry! I wasn't reading the error. Here is the error that I'm getting:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (comma) in query expression 'logId = 43, 48'

Any help is appreciated!

Thanks!

Reply With Quote
  #4  
Old November 20th, 2003, 12:48 AM
unclefu unclefu is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Nov 2003
Posts: 120 unclefu User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 30 m 57 sec
Reputation Power: 5
in that specified error you posted


logId = 43, 48.... where are you getting these two values from?

Reply With Quote
  #5  
Old November 20th, 2003, 01:17 AM
sachinborkar sachinborkar is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Nov 2003
Posts: 99 sachinborkar User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 3 h 12 m 17 sec
Reputation Power: 5
Try logId in (43, 48) if nos are in integer datatype
else logId in ('43','48') if nos are in varchar datatype

Reply With Quote
Reply

Viewing: Dev Shed ForumsProgramming Languages - MoreASP Programming > Newbie question about URL Parameters


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 3 hosted by Hostway
Stay green...Green IT