| |
| |
| |
|
Page: 1 2 3 4 5
Comments:
<0> StreetNum is not a numeric datatype
<1> ahhh
<1> that is very true
<2> how do i group conditions in a mysql query? like condition 1 AND (condition2 OR condition3)
<0> did you try that?
<2> crap! uhm.. thanks lol
<3> is there anything wrong with this statement ?
<3> "insert into Login (Username, P***word, Email) values (" & _
<3> strInputUsername & ", '" & strInputP***word & "', " & strInputEmail & ")"
<3> i keep getting an error syntax in insrt
<4> show the string in a messagebox
<4> wtf
<3> ok
<4> and then you see where the error is
<3> how do i call a message box
<4> sfsf
<3> just messagebox string?
<3> msgbox?
<4> scary ...
<4> this particular channel has a buffer problem in my client
<4> I don't see what I write
<3> mmm xchat
<3> u should use bitchx
<5> irssi
<4> I use irssi when I'm nixin
<4> zillabunn: No idea, debug.print, messagebox, whatever your system supports
<3> insert into Login (Username, P***word, Email) values ('asf', 'asdf', 'asdf')
<3> ok it's spitting out that as my string
<3> i used response.write string
<4> could be the space in front of the parenthesis
<4> dunno what you use :)
<5> teehee
<5> keywork
<5> *d
<3> hmm/
<3> naw it's not
<5> mebee
<5> login?
<3> hmm
<5> it is
<3> thats what someone else said
<3> lemme try
<5> well i wouldnt listen to them either
<4> what happens if you use the last line you just pasted
<3> ??
<3> i don't know how to parse commands directly to my SQL server
<3> i use ASP
<4> insert into login (a,b,c) values('a','b','c')
<4> k
<5> oh
<5> login isn't as keyword
<4> yeah could be that :)
<3> Microsoft JET Database Engine (0x80040E14)
<3> Syntax error in INSERT INTO statement.
<3> /game/create.asp, line 27
<3> dammnn it
<3> it's gonna be pretty frigging hard to make an online browser based RPG if i can't even add a frigging record to a database
<4> perhaps asp require double quotes
<3> well heres the thing
<3> sql_insert = "insert into contacts (LastName, FirstName, Email, CUSTNAME) values ('" & _
<3> strInputLast & "', '" & strInputFirst & "', '" & strInputEmail & "', '" & strInputCust & "')"
<3> that works
<3> but sql_insert = "insert into loginz (Username, P***word, Email) values ('" & _
<3> strInputUsername & "', '" & strInputP***word & "', '" & strInputEmail & "')"
<3> doesn't
<4> and what is the default value for CUSTNAME ?
<3> different databases
<3> default?
<4> nm two different tables
<3> yah
<3> two seperate projects
<3> i'm totally stumped
<3> i've been workin on this for 3 hours now
<4> anyway: you could try sql_insert = "insert into loginz(username, p***word, email) values('a','b','c')
<4> "^
<3> do i need to define a b or c?
<3> or will it just throw them in as strings?
<3> oh ****
<5> int column or something
<4> rewrite your question
<3> i'm not sure how
<3> i think i'm gonna go oto bed
<5> you're problems will still be there when you wake up
<3> :(
<5> what dbms is this?
<3> your statement didn't work
<3> dbms?
<6> zillabunn don't paste to the channel
<3> access?
<3> Sorry Darken
<5> can you open the db in access?
<5> or do you not have access but can somehow create mdb's?
<4> my statement =?
<4> what error did you get
<3> yes i can
<7> how much is an msdn sub these days?
<5> cant be right, ms site says $199
<5> for the library
<5> which == every ms product for download
<8> Is there anyway i could display 'Qty' on the results when i type select sum(Qty) from table2? cause i seem to get SUM on the results
<5> select sum(Qty) as Qty from table2
<0> phargle: MSDN Library is just the documentation
<5> oh right wow.. haha. i dont see mine, i thought i have a "universal subscription"
<7> how much?
<9> if universal subscription was $200, i would have done it since i was 5 years old
<9> s/done/subscribed it
<5> i dunno they dont have subscription prices i guess
<7> halo
<7> how much did you pay?
<9> i wanted go for professional one
<9> which was hmm around $1200... like few month ago
<9> let's see.. it was around $3/day... hmm
<7> hmm
<7> why do you calculate per day? hehe
<9> lol that was because,.... hmm there is a reason behind it
<7> msdn sub allows you to do what? develop using the products?
<9> you basically get to download "developer" version of products...
<7> so you can't run your website on that ****?
<5> not legally
<9> they have limitations...
<9> exactly. not legally :)
<7> faken lame or what?
<5> i think its expensive, but as long as my company is cool with paying for it, it's an invaluable tool
<9> oh yeah, heard that a lot of people get their subscriptions through their companies... *sigh*... while i can't even ask my super for it
<7> why not?
<9> i am about to leave the company.
<7> ask anyway
<5> oh no thats the best time
<9> lol
<5> download a bunch of stuff so you can keep your mad skillz while unemployed
<9> oh yeah, i think spending $1000 on my last cpu really did it... hmm
<9> well my cpu was twice as expensive as my 19" LCD...
<5> my laptop costs more than most cars
<9> anyways, time to reboot... stupid windows updates
<5> nah j/k
<7> hehe
<7> wow vs2k3 never had service packs?
<7> Jarett you there?
<7> does anyone know where i can download sql*net? client app
<10> hey Quant
<10> u any good with sql?
<10> msSQL
<11> hrm, what's better ...
<11> Turion 64 or Athlon 64 ...for a laptop
<12> im trying to run a query in sql which shows me all users who've signed up past a certain date, I use this command in query analyzer - show * from [user] where 'ActiveDate' > 31 Jan 2006
<12> but i guess an error saying incorrect syntax near 'X'.
<13> Thomcat: What db?
<12> what do u mean what db?
<12> i have a db called user
<12> ...anyone?
Return to
#sql
or
Go to some related
logs:
#stocks
#tcl
#beginner
#gentoo
#visualbasic
#gentoo
#gamedev
#beginner
#flash
goatsegirl
|
|