| |
| |
| |
|
Page: 1 2 3 4
Comments:
<0> her flece was white as snow <bar
<0> and avery where that mary went <bar
<0> the lamb was sure to go <
<1> maryhadalittlelamb|little lamb little lamb|mary had a little lamb her flece was white as cum|
<0> wtf
<0> hehe
<1> then you can prase based on the |
<0> yeah. it hink ill do it that way...
<0> if thats better than a bar per field!
<0> yeah cool thx
<0> for da info :D
<0> how many letters can a field hold?
<0> 8060?
<0> i mean column
<2> anyone have experience with this dotnet namespace: Microsoft.SqlServer.Management ?
<3> i can't get my where statement to work heres my command anyone tell me why its not working
<3> union select name,number from orders where number <> ''
<3> says theres a prob with number <> ''
<4> t-bore : what datattype is 'number', and what actual error do you get
<4> also, what rdbms is this for?
<3> its a int
<4> t-bore : if it's an int, why are you comparing it to an empty string?
<4> and why only answer one of the three questions i asked?
<3> how do i compare it to an empty int
<4> t-bore : answer all the questions first
<3> what other question
<4> [12:20:02] <4> t-bore : what datattype is 'number', and what actual error do you get
<4> [12:20:08] <4> also, what rdbms is this for?
<3> access
<4> [12:31:25] <4> t-bore : if it's an int, why are you comparing it to an empty string?
<3> i want to compare it to empty int
<4> what do you mean by 'empty'?
<3> no value
<4> last i looked, ms-access had no such concept as 'empty'
<3> ok then something
<3> where number equals something
<3> how do i do that
<3> instead of number does't equal nothing
<4> i think you need to look up the word 'null' in your documentation
<4> it's missing from your vocabulary
<3> number > null ?
<4> no
<4> don't guess - read!
<3> i'm not seeing any answers to read
<3> lol
<4> then you're not looking properly
<3> number <> null doesn't work
<4> correct
<3> then what would i use?
<4> the documentation
<3> pretty vague and time consuming
<4> yes you are, but i'm trying to help anyway
<3> i came in here for help
<4> and you're getting it
<3> "read manual" thats not help
<4> what you're not getting is a spoonfed answer
<4> that's not what i said
<3> i'm not getting an answer period
<4> i said look up 'null' and read about it
<3> i've googled it for the past few hours and i'm still not finding how to compare something to null
<4> i don't remember telling you to use google - i told you to use the documentation
<4> documantation != google
<4> where rdbms==ms-access, documentation='f1'
<5> morning
<3> this paper clip is not very helpful
<4> then don't use the paper-clip, read the documentation about 'null'
<3> not helpful
<4> if reading the documentation is giving you this much problem, perhaps you should re-think your whole purpose is using a computer - sell it and buy a psp
<3> number is not null gives error
<3> thats what the docs say to use
<4> WHAT ****ING ERROR, FOR THE THIRD TIME OF ASKING?
<3> one sec gunthy
<4> don't call me gunthy, cock-face
<3> lol
<3> thought you'd get a kick out of that
<4> now, *that* was funny
<3> thx yuppers
<6> I try to show all rows that have field 'abc' <> 'X'; I try this, bat is not showing NULL fields: SELECT * FROM tabel_1 WHERE aaa NOT LIKE 'X'
<6> can someone help me please ?
<7> add OR aaa IS NULL
<3> another null question...
<6> t-bore: I try to show all rows from tabel_1 where field 'aaa' <> 'X'
<6> t-bore: I try to show all rows from tabel_1 where field 'aaa' <> 'X' even 'aaa' = NULL Can you help me please ?
<7> 09 15:06 < upb> add OR aaa IS NULL09 15:06 < upb> add OR aaa IS NULL09 15:06 < upb> add OR aaa IS NULL09 15:06 < upb> add OR aaa IS NULL09 15:06 < upb> add OR aaa IS NULL09 15:06 < upb> add OR aaa IS NULL
<6> thank upb
<6> upb: sorry I don't sea your first line
<7> i know, thats why i flooded it into your brain
<8> wooooo... NyQuil's back!
<9> I get this error when using SET @var=(SELECT ...): Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
<9> any idea why? it worked before...
<9> (MsSQL 2005)
<7> its because it returned more than 1 value
<7> doh
<9> it happenes when I use TOP 1 too, doh
<4> because *before* it only returned one value
<4> run the select on it's own
<9> GuntherX ?
<9> before? when is it?
<4> [16:31:43] <9> any idea why? it worked before...
<4> [16:33:22] <4> because *before* it only returned one value
<9> yes, but now there is still only one record in the table I'm querying
<4> run the select on it's own
<9> I did, and it returned only one field, and one row
<9> what would help me is having this value stored as a global var visible and accessible to all DB threads
<9> is that possible?
<4> too bad
<4> no
<4> ah
<4> depends on the rdbms
<4> which rdbms is it
<4> ?
<9> SQL Server 2003/2005
<9> [18:31] <9> (MsSQL 2005)
<4> no such thing
<9> :(
<9> any idea what could be the issue I'm experiencing, or how I can byp*** it?
<4> well, if the actual select only returns one row of a single col, then either the error is somewhere else, or your database is broken
<7> maybe you ran a delete query in your session and didnt commit it?
<9> I did run a DELETE, but not within a transaction, and not on that specific table
<9> GuntherX I will look if its in somewhere else, but as far as I checked now it is there
<9> I'm reading something on SET ROWCOUNT - would it help me at all?
<10> Bronso:: have you tried "select @var = blah from table"
<10> wait a sec. it's not a recommended way so might have discontinued that in sql 2005
<10> well i don't know about sql 2005
<9> d2d_w0rk this is the line: SET @LockState=(SELECT TOP 1 Cfg_Lock FROM Tbl_Config WHERE Cfg_ID=1)
<11> SELECT TOP 1 @LockState = Cfg_Lock FROM Tbl_Config WHERE Cfg_ID=1
<10> Bronso:: well i did something like(in sql 2000) set @var = (select top 1 spid from master..sysprocesses) where @var is of type int and it's working fine
<10> but not sure if that's the problem with sql 2005 or not
<9> Halo_Four you sure that gonna work at all?
<10> Bronso:: you never know until you try
<10> i told you try out "select" version as well
<9> d2d_w0rk I'm trying fixing it with ROWCOUNT now
<10> having to using rowcount is a bad practice in your case i say
<12> anyone awake?
<10> but then.. whatever works
<10> s/whatever/whichever
<12> im using mssql 2000 with sp3 and hotfix update.. al the permissions are set correctly. The html page calls for a userid - p*** to access the DB different from the "sa". I am getting an access denied and im stuck
<9> d2d that seems to work - I'm testing it more thoroughly now
<10> which version?
<10> rowcount? top1? or select?
<12> that for me?
<10> nope.
<12> poop
<10> bah~
<10> nikkie:: what do you mean by "p*** to access the DB different from 'sa'"?
<12> sec...
<9> d2d_w0rk rowcount and top1
<9> it still errors in another section tho
<12> in the html file it calls Provider=sqloledb; data source = (local); initial catalog = avtronics; user id = avlogger; p***word = p***word
<12> the log gives me an avlogger_access_denied
<12> wen i try to access the db
Return to
#sql
or
Go to some related
logs:
#nhl
giganews account hack
#linuxhelp
#linuxhelp
#gentoo
#nhl
medion MD6471 driver
#politics
#dsl
#gentoo
|
|