| |
| |
| |
|
Comments:
<0> can anyone see something wrong with this query: SELECT * FROM [Search_Words] WHERE TRIM([Word]) = 'kidspiration'
<0> everytime it runs through ASP, it comes up with no records, but when I run it right from Access, it brings up tons of records...
<0> anyone alive in here?
<1> yes sir
<1> is TRIM() a function in ASP or in Access ?
<0> it's being used as a function in Access, withint he query
<0> it gives me the same result with or without the trim() function in there
<1> okay
<0> SELECT * FROM [Search_Words] WHERE [Word] = 'kidspiration'
<0> ^^ same thing
<0> er, same result
<0> 0 records
<1> in your asp, try response.write sql
<1> and check it
<0> that's what the query's from
<0> this is it in the asp: SQL = "SELECT * FROM [Search_Words] WHERE [Word] = '" & lcase(w) & "'"
<0> w = trim(replace(r(x), " ", ""))
<0> i just can't figure out what i'm doing wrong with this....everything looks right to me
<0> can you see anything Aller
<0> ?
<0> or anyone else?
<1> afraid not, sorry... dinner's ready :>
<0> ok...thanks for the help
Return to
#asp
or
Go to some related
logs:
juba sniper media
#computers
#hardware
#politics
pre-hizbollah
#computers
#worldcup
pfft undernet admins
#flash
#gamedev
|
|