|
|
|
|
|
| | |
| |
PowerASP active server pages asp.net microsoft .net framework sdk learn asp what is asp tutorial learn asp.net CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Need help on query |
|
From: |
Greg |
|
Date: |
8/21/2002 10:08:13 AM |
|
IP: |
216.144.25.14 |
I get the following when I run an update query.
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'path like d:\home\gambit\greg\test2\upload\2\test.doc'.
I cannot figure out what I’m doing wrong! Can someone help me out?
This is the complete code and everything works except the last line.
'--- Move file
if len(Request("lstFile")) > 0 then
rayFile = split(Request("lstFile"),",")
for i = 0 to ubound(rayFile)
fromPath = safePath(Session("DirPath") & "\" & trim(rayFile(i)))
toPath = safePath(To_DirPath & "\" & trim(rayFile(i)))
if fromPath <> To_DirPath then
fs.MoveFile fromPath, toPath
Conn.Execute "UPDATE search SET path='" & topath & "', folder='" & topath & "', search_url='" & topath & "' WHERE path like " & frompath
|
Follow Up - Re: Need help on query - ASPguy 11/26/2002 4:49:51 PM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
