|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
September 5th, 2004, 08:46 PM
|
|||
|
|||
|
%20 in SQL db
mySQL1 = "Delete FROM bookmarks WHERE url = '" & url & "'"
im using the query above to delete bookmarks but some of them in the db have %20 between spaces and the one its checking against on the webpages does not. how can i make the query string above ingore %20 in the database fields?
|
|
#2
September 5th, 2004, 09:55 PM
|
||||
|
||||
|
Are you trying to run this query inside of an ASP page?
It looks like you are trying to do that. You can try this: Quote:
__________________
Freelance Programming Rates Available - For More Info Please Contact Me Imagination Is More Important Than Knowledge -- Albert Einstein
|
|
#3
September 5th, 2004, 10:59 PM
|
|||
|
|||
|
come on messanger when you get a chance coinhunter
Quote:
|
|
#4
September 7th, 2004, 05:20 PM
|
|||
|
|||
|
Code:
mySQL1 = "Delete FROM bookmarks WHERE REPLACE(url, '%%20', '') = '" & url & "'"
__________________
Up the Irons What Would Jimi Do? Smash amps. Burn guitar. Take the groupies home.
|
|
| Viewing: ASP Free Forums > Database > Microsoft SQL Server > %20 in SQL db |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
