Need help - URL string concentration

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

Need help - URL string concentration

Logged in as: Guest

arrSession:exec spGetSession 2,3,3588

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> ASP >> Need help - URL string concentration
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

Need help - URL string concentration - 6/30/2005 2:19:00 AM

osmarmedia

Posts: 2
Score: 0
Joined: 6/30/2005
From:
Status: offline

I� ve used Dreamweaver MX to generate the following script on a page.

<A HREF="detail.asp?<%= MM_keepURL & MM_joinChar(MM_keepURL) & "ProdID=" & rsProdPic.Fields.Item("ProdID").Value %>">

What I need to do is edit the script so that it works with the detail.asp page
sending the URL to itself. What�s happing is that once the page has sent the string to itself once, when the string is sent again it appends the "ProdID=� variable onto
the existing URL giving two "ProdID=� variables. This results in the following error:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (comma) in query expression 'ProdID = 117, 118'.

How do I make the variable update/replace rather than append?

Cheers,

Gregg

Post #: 1

RE: Need help - URL string concentration - 7/12/2005 1:45:22 PM

vietnamblood

Posts: 14
Score: 0
Joined: 3/28/2005
From:
Status: offline

you must talk database specific
Access or sql?

(in reply to osmarmedia)

Post #: 2

RE: Need help - URL string concentration - 7/14/2005 12:00:25 AM

VBS

Posts: 110
Score: 0
Joined: 3/2/2005
From: Lebanon
Status: offline

Dear osmarmedia,
This is a well known error, and it used to happen to me alot, so what i need from u is to give me the variable's data in the link, plus the lines that executes when u click on the link. And i will c what i could do for u.

Best Regards
Firas S Assaad

_____________________________

Anything in VB or VBScript or ASP email me or IM on firas489@hotmail.com or firas489@gmail.com

(in reply to vietnamblood)