| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10
Comments:
<0> <2> : use the right paste site, ****o
<1> you need a left outer join
<2> on both the tables
<1> yeh
<1> why are you using a right join?
<2> i tried RIGHT LEFT and INNER all with same results
<1> also in your where clause
<1> http://media.kladblog.com/media/200603/bad_***.wmv
<1> oops
<1> dont click
<1> rofl
<1> in your where clause
<1> AND module_courselocations.location_suburb LIKE '%%'
<2> now im curious
<1> well it's not worksafe
<1> if you are not at work then CLICK yesss
<2> i work from home so meh, ill click
<2> about the where clause??
<1> yea the where clause
<2> you were gonna say something
<1> that columb could be null since you are left joining
<1> column
<1> so the LIKE will fail and you are not going to get any results for those that dont have a location or a schedule
<1> you need to do
<2> aha, i see what you mean, i think
<1> isnull(module_courselocations.location_suburb,'')
<1> well play around with it
<2> ill try this outer join
<2> thanks for yer help ill have a fiddle
<1> during noob phase
<2> back to the manual i guess
<1> start out simple
<1> and then build onto it
<1> i suggest you should have one WHERE item and one join to make things simple
<2> yeh, i can get the one table working, as soon as i go to add one of the other tables i started having problems
<1> don't add two right away
<1> add one and see how it works
<1> you are wasting time by trying to get everything to work in one shot
<2> i did that a couple of weeks ago, only coming back to it now, i thought ****it and got most of the other stuff working, now this is sort of last thing
<2> ill do what you suggest though and cut it right down to a few fields and two tables
<1> don't forget ISNULL()
<2> thanks for the help, i wont and i will read in the manual about it too
<1> wait what DB do you use? if no ISNULL then COALESCE same thing
<2> youll hate me, but mysql
<2> ive got my head in the manual atm
<2> youve been most helpfull though, thankyou
<2> http://www.shawnolson.net/a/730/ just quickly is this the sort of stuff your talking about
<3> can anyone tell me what im doing wrong here?
<3> LEFT(CAST(abstract, varchar), 100 AS teaser)
<2> i think i said the dirty word mysql :P hehe
<3> Hey can i use SELECT LEFT with a text data type
<3> ?
<4> Why do I get the error "Line 44: Incorrect syntax near '#tmpToolkitDox'" on this MS-SQL 2000 code? http://sql-servers.com/nopaste/?show=392
<4> this was working on our dev box and somebody made a change and I need to fix it
<4> oh line 44 is line 48 on the paste
<5> what was the change? you have the previous version of course?
<4> no, this is all I have to work on
<4> I was told it has something to do with how he handled the temp table
<4> it was a very minor change to
<6> is it a scope problem?
<6> since the temp table is created inside cursor?
<6> try explicitly creating the temp table
<4> I moved the SELECT inside the cursor, same error
<6> is line 48 the last line of the sql?
<4> yes
<6> will the sql execute w/o the select
<4> that paste site has lame wrapping, it gives wraps line #s
<4> no
<4> hmm it errors at line 44 even when it's rem'd out
<4> I gutted the cursor, says "Line 18: Incorrect syntax near 'Dox'."
<4> oh god we're all idiots
<4> it's missing an END... although there is another problem
<5> now here's a topic: <4> oh god we're all idiots
<4> I'm included :)
<5> you can feel the comp***ion flowing
<4> If you refresh http://sql-servers.com/nopaste/?show=394 you will see I'm getting "A cursor with the name 'Dox' already exists."
<4> I'm not very cursor or temp table savy.. any ideas?
<4> isn't the cursor destroyed because of the close & delocate
<4> oh, I had one hanging out, closed & delocated it.. now I get "Invalid object name '#tmpToolkitDox'"
<1> rofl
<1> change
<1> INSERT INTO into a
<1> SELECT a,b,c INTO #MYTEMP
<1> no
<1> in your case
<1> you need to declare that table
<1> declare @mytemp table(a int, b int, c int)
<4> @ but this is #
<1> so?
<1> # is for select into
<4> ahh
<1> or
<4> ok hang
<1> change your first INSERT into
<1> into a select into
<1> and leave others like that
<1> becasue after the first statement the temptable will actually exist
<4> Quant: that syntax gives me "Incorrect syntax near the keyword 'TABLE'"
<1> paste
<4> DECLARE @tmpToolkitDox TABLE([DocumentID] INT,[Title] VARCHAR(128),[FileName] VARCHAR(128),[ParentDocumentID] INT,[DisplayOrder] INT,[Active] BIT)
<1> seems ok
<4> that's the line it errors at
<7> this is a retard question, but how can i get the time of a given datetime field in this format: hh:mm
<1> tapped
<4> tapped: I do my date formatting in my apps
<8> quant ?
<7> it's not part of an app
<1> convert(char(5),mydate,<insert code here that i forgot>)
<4> I wrote a VERY flexible VBScript function for it
<8> help a fellow jew ;)
<9> dirty jew you mean.
<1> shudddaaap
<1> ok who still needs help? i am confused
<1> haha df you got pwned
<4> Quant: my error
<4> btw here's my custom date formatter for VBScript http://rafb.net/paste/results/Yib5J338.html
<1> oh yea
<4> you might find the format syntax a little.. umm, thick
<1> tapped
<4> but it works great
<1> so you're using mssql?
<4> yes, 7 on dev, 2000 in prod, will upgrade dev soon
<1> not you
<1> tapped......
<4> well let me know when you want to help me with that syntax... waiting
<1> anyway tapped, if you are using sql server, convert(char(5),mydate,108)
<1> anyone know equiv of ISNULL() in Access?
<7> awesome
<7> thanks man
<4> Quant: I was told it is ISNull()
<7> much appreciated
<1> no it's not equiv to mssql's
<1> i guess
<1> iif(isnull(myfield),'',myfield) is fine
<4> I asked our Access guy here, but the Access expert is away
<1> tell him he's a noob
<4> k
<1> isnull() in access is boolean
<1> ****ing vba
<9> if he's jewish, then he's a j00b
<1> watch out for Cooje's foot
<4> Quant: 'WHERE column IS NULL'
<1> nah nah
<4> Quant: 'WHERE ISNULL(column) = TRUE'
<1> equaive mssql's ISNULL() aka COALESCE()
<4> that's what the expert said
<1> tell him he's a noob too
<1> dfworking: how goes it?
<4> did you try the 2nd syntax?
Return to
#sql
or
Go to some related
logs:
#windows
sweetnaturalgirl.com member
fuckup kickball
#unix
#gentoo
perv.babes
#redhat
acromancers
#computers
#computers
|
|