| |
| |
| |
|
Comments:
<0> how can I do a datediff in a sql statment?
<0> i tried this " AND DateDiff( 'MM', SiteUsers.LastLogin, " & Date() & " ) <= 3 " &_
<0> anyone have any idea how i can do a datediff in a mysql where statement?
<1> #mysql
<2> @find gay
<2> !list gay
<3> results: ThaliaSod
<2> how does this works
<3> <% Response.Write "This is not a pr0n channel" %>
<3> <% Response.End %>
<2> i thought it was
<2> (File Servers Online) Trigger: /ctcp ThaliaSod Some Music!!!!!. Snagged: .17Gb in 199 files. Record CPS: .5Kb/s by pilotin. Online: /4. Sends: /1. Queues: /10. Accessed: 1 times. Note: Just type the Trigger!. ~{Polaris SE}~
<3> wtf
<3> go away with thta
<2> (File Servers Online) Trigger: /ctcp ThaliaSod Some Music!!!!!. Snagged: .17Gb in 199 files. Record CPS: .5Kb/s by pilotin. Online: /4. Sends: /1. Queues: /10. Accessed: 1 times. Note: Just type the Trigger!. ~{Polaris SE}~
<3> ThaliaSod; turn that **** off
<2> (File Servers Online) Trigger: /ctcp ThaliaSod Some Music!!!!!. Snagged: .17Gb in 199 files. Record CPS: .5Kb/s by pilotin. Online: /4. Sends: /1. Queues: /10. Accessed: 4 times. Note: Just type the Trigger!. ~{Polaris SE}~
<4> !help
<2> (File Servers Online) Trigger: /ctcp ThaliaSod Some Music!!!!!. Snagged: .17Gb in 199 files. Record CPS: .5Kb/s by pilotin. Online: /4. Sends: /1. Queues: /10. Accessed: 5 times. Note: Just type the Trigger!. ~{Polaris SE}~
<2> (File Servers Online) Trigger: /ctcp ThaliaSod Some Music!!!!!. Snagged: .17Gb in 199 files. Record CPS: .5Kb/s by pilotin. Online: /4. Sends: /1. Queues: /10. Accessed: 7 times. Note: Just type the Trigger!. ~{Polaris SE}~
<5> Okay you may think of this was a waiste of your time, but does anyone know how to access the MySpace database directly to insert "comments" onto another page?
<6> i'm trying to write into database a text field with ' signs and i get an error, how can i solve that ?
<6> i'm reading asp source code from database and response.write it, when it gets to <% %> (asp commands) it ignores them, how can i solve that?
<7> i don't think you can...
<6> MuteThis: so if i read content from database, what is the best way to present it that it will read both html tags and asp actions?
<6> MuteThis: got any answer?
<8> i'm going to agree with Mute
<8> asp is executed server side
<8> so grabbing it from a db then trying to write it then execute shouldn't be feasible
<8> unless
<8> you give them write permission to the directory
<8> then you could write the page, then redirect to it
<8> that is, give the IIS_USR ident write permission
<9> i need help with an xml issue: http://www.phpriot.com/3325
<10> hey i have a query that run in the access but doesnt run in the asp page, i get the error[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 5.
<11> paste the code to www.nomorepasting.com
<10> the query is : http://sql-servers.com/nopaste/?show=853
<11> that works too
<12> error in sql statement
<10> but it runs in the access
<11> wow, that is an ulky query...
<10> :)
<11> ugly, too
<10> well if u can find a better way to do it i would like to hear :)
<12> replace " with '
<11> if you were to copy/paste that query exactly as it stands into the Access query builder (NOT the graphical one), and run it, what happens?
<10> runs
<11> you've done exactly this?
<10> with the good results
<10> i did response.write sql , response.flush
<10> and pasted the query in access
<10> and it runs
<11> that error usually means that you're requsting a field that does not exist, or is misnamed
<12> sub selects as calculations ? ... geez
<10> well its not exact query... i did some changes... but i tested the changes in access and works too
<10> i did it in other place with asp code
<11> well we don't want the 'same changes'...
<10> but the problem i need to sort the results by the ret val aka rank
<10> k ill paste the new working(access)\nonworking(asp) query
<10> but it wont be formated
<10> http://sql-servers.com/nopaste/?show=854
<10> http://www.nomorepasting.com/paste.php?pasteID=65155
<10> what u think ?
<12> " .... Order BY 7 DESC" ????
<10> ya
<12> what is 7 ? ... fiels .. alias ?
<12> field even
<10> that order by the 7th field
<12> dont think that will work in asp
<12> a guess
<10> i had to use it coz it didnt order by Rank
<10> =\
<12> try to remove the order by ... and see if it makes a diffrence
<12> +e
<10> nop
<10> it doesnt
<12> remove all sub-selects .. and insert them one of the time ... easier to find the error
<10> i tried to use recordset.sort but the problem is not there
<10> hehe im working on this query for about 3 hours to make it work in the access...
<12> but it works in access ???
<12> remove each sub-select ... and run it in asp ... add the sub-selects one by one
<10> yep
<10> k
<10> sec
<11> also verify that you're connecting to the proper database
<10> hehe im...
<10> found the prob
<10> it was the ""1""
<10> suppose to be 'x'
<10> =\
<10> thx ppls
<13> anybody know how to get file owner?
<13> ntfs owner
<11> From ASP?
<11> You'll need an external component
<12> or running cacls
<12> but, yes ... you'll need a component for that
<14> is www.freeaspupload.com the easieset way to upload pictures via a web interface?
<11> it's one of the ways to do it
<11> 'easiest' is very subjective
<14> do u know of another popular one?
<14> i had no idea it was so complex
<14> i got the freeaspupload to work but its not perfect
<11> PureASP Upload is another one
<11> but I've not used either in quite a while
<11> there's probably a bunch more
<3> you could also write your own :)
<14> heh
<14> u can fo that aller?
<14> do
<11> anyone can
<13> ....
<11> anyone could, rather, ***uming they know how
<13> its actually for a vbscript, not an asp script
<3> well, someone wrote the existing ones, so why cna't you write one? :)
<14> ok
<13> but it's still vbs code i guess
<14> i knew its possible but haha not for me
<14> i opened the two files and it was a mess lol
<13> cacls could do the job
<14> whats cacls
<12> start dos-prompt .. type cacls =)
<13> its the command in windows to retrieve file information
<12> eg. cacls C:\ .... gives you NT users / groups on c: root
<14> thats some cool stuff
<14> http://www.freeaspupload.net/ thats the site i was talking about anyway
<12> Regarding nt users ... you might wanna look at MS Scripting section ...
<12> or Script center
<12> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnanchor/html/scriptinga.asp
<12> Retrieving File Ownership ... http://www.microsoft.com/technet/scriptcenter/scripts/default.mspx?mfr=true
<13> great mm2k
<13> <3
<13> btw do you know a way to retrieve logged on users?
<13> on a terminal server?
Return to
#asp
or
Go to some related
logs:
antivirus overrider
#sql
#debian
#tcl
#politics
#mirc
#nhl
#beginner
brainy.png
service-error-service-unavailable
|
|