| |
| |
| |
|
Page: 1 2 3 4 5
Comments:
<0> You can define a variable prior, select the values from the table into the variable and then p*** the variable.
<0> or, if this applies to multiple rows, a cursor.
<1> yeah multiple rows
<2> Hi
<2> Let's say I have a master-detail relation in which the detail is garanteed to always have 2 records, is there any way to display the 2 records at once in 2 textboxes and benefit from 2-way databinding (.net 2.0 windows forms, ms sql backend) ?
<3> I'm trying to dynamically build a dump device on SQL Server 2000. Any know if it's possible?
<4> yes
<3> drhyde: what I'm trying to accomplish is to change the file ***ociated with a dump device on the fly (ie. fileYYYYMMDDHHMM)
<4> ok
<4> you need to use dynamic sql
<3> do I even need sp_addumpdevice and sp_dropdevice ?
<4> yes
<3> I know how to create it and drop it... I don't know how to test it's existence in order to drop it...
<4> hmm, where to look for that?....
<3> I'm going through books online at the moment...
<5> why can't I put a single quote in a field? (e.g. D'Voire would be 'D\'Voire'
<5> I'm using MsSql 2000
<4> '''
<4> ' is the string identifier
<4> 'D'''Voire'
<5> Oooho I seee. Thanks
<5> I have this in mssql 2000, there any reason why it wouldn't be working? alter table projects
<5> RENAME COLUMN descriptoin to description
<0> Yeah, don't invent SQL syntax. Look into sp_rename.
<5> lol
<5> thanks
<1> trying to run a cursor for the first time, but not sure how I'd optimize this: http://sql-servers.com/nopaste/?show=132
<1> if anyone could give me some pointers on what to add/remove to just the cursor, much appreciated
<1> ...very simple cursor, btw
<6> ducch I suppose you can
<6> you can use FROM in update
<7> meep
<7> Any DB2 dudes here ? I've mapped some tables from z/OS to LUW through federated, when I update a decimal(10) with default 0 column to any number > 0, it succeeds. when I update to 0 it fails with -104, although the statement is correct. Updating directly on the mainfram is working.
<8> check the flux capacitor and if thats working ok, toggle the numeric contusial floggletang and verify that its running within 4mA of the arc cotangent of Pi. or maybe its just not plugged in?
<7> ah doh I forgot about that
<8> its always something simple
<7> btw. this is homework
<7> thx df
<8> np man
<8> can't you just run an update on those cols with zero and give it some high number, set the default, then update again and set them back?
<8> lunch, bbiaf
<7> it's not that simple :o)
<9> This code SELECT * FROM Table1 WHERE C1 LIKE 'c1' ORDER BY C1 ASC LIMIT 20, 30 work, but if I order by c2 I receive ather rows, whay? I try to use 30 rows per page. Can someone help me? Sorry for my bad english.
<10> please explain more
<10> are you saying that if you order by C1 you get one set of rows, but if you order by C2 you get different row? not the same rows ordered differently?
<9> yes
<9> :)
<10> ok, why are you using LIMIT?
<9> I try to show some set of rows per page1 and some set of rows per page 2
<10> ok
<10> then I'll ask you a few questions
<10> suppose you order by C1, then go to the first page
<10> then you go to the "next page"
<10> ok, then you order by C2 and go to the first page
<9> yes
<10> do you expect to see the same rows as when you ordered by C1, or do you expect to see the first rows according to C2?
<10> and then, when you go to the "next page", do you expect to see those following those on the first page or the same rows as page 2 of C1?
<9> I my site I show 30 rows per page, is work ok for all pages, but If I sort by ather column I receive ather set of rows per page
<9> I try to receive the some set of rows, but sorted by ather column
<9> You understund me ?
<10> ok, if you sort by C1 and show the first page, and then sort by C2 and show the first page, do you want to see the same rows?
<9> yes
<10> ok, so let's say that ordering by C1 shows rows 1, 2, 3, 4, 5
<10> and ordering by C2 shows rows 3, 5, 2, 4, 1
<10> ok?
<7> I bought a blue car, then I painted it black. Why ain't it blue anymore ... I simply don't get this
<9> ok
<10> what if you, when sorting by C2, go to page 2, would you like to see rows 6, 7, 8, 9, 10, only sorted by C2?
<10> typically, when you sort by *something*, first page shows those that are sorted first
<10> page 2 shows those that come after
<10> and that, by necessity, means that page 2 when sorted by C2 will not show the same rows as when you sort by C1
<10> let me rephrase: it might confuse the user
<10> in any case, what you need to do is do one query with the ordering by C1, then place that in a subselect that orders by C2, and on the outer select you apply the limit
<10> sorry, inner select
<10> something like: SELECT * FROM (SELECT * FROM ... ORDER BY C1 LIMIT 20, 30) ORDER BY C2
<9> :) thank for your help LVK
<9> I will try now
<10> let me just ask one question before you go on
<10> did you understand anything of what I wrote above, except for the SQL?
<9> ok
<9> yes :)
<10> doubtful, but ok
<9> :)
<10> I don't have a wife, but she better come equipped with slippers, yes
<10> I'll be sure to check the feature matrix before comitting
<7> hehe
<7> btw. I bought the sigma f2.8/70-200 apo dg hsm whatever ... very satisfied
<10> nice
<7> almost the same price as the canon without IS
<7> but I have trouble using the f1.4/50mm
<10> I got the Canon EF 70-300 F/4.5-5.6 DO IS USM just before christmas
<7> can't get it to focus correctly in auto modes
<7> wow
<10> but F/4.5-5.6 means it's not much usable in the weather and light we have these days :(
<10> I'm longing for summer right now
<7> with 18 deg. last night it's close
<11> plenty of great winterl ight
<10> no winter light here, just bad weather
<10> gray overcast :(
<11> overcast is some of the best light.
<10> http://www.photo.net/equipment/canon/70-300do/ <-- the one to the right on the photos
<10> not for a 300mm IS F/5.6 lens
<12> Hello orcale have datatype long in a db i want to print out the column using a where clause and get a error about it being long
<13> hey, how do i import a .sql file by shell ?
<11> long datatype is deprecated. but im not sure you are talking about the same thing with the where clause
<7> angellll: db2 -vf filename.sql
<13> i meant by linux shell
<11> b3nj|mcc, you cant really use sqlplus to get the full contents of a long column. please be more specific on what you need to do
<7> angelll: DB2 CLP is the same in windows, unix and windows
<7> doh windows, unix and linux
<13> well look
<13> [root@www htdocs]# db2 -vf 1955k.sql
<13> bash: db2: command not found
<7> Ibet you're not using DB2
<7> bbl reading article
<7> amazing what a blender can do with an image
<7> I'm playing with cokin filters now, quite fun but they are expensive the good ones
<13> imusing mysql
<11> cokins are all cheap :P compare them to sighn ray or some of the lee
<11> thats expensive
<12> i need to dump, out a colum for a specific id which is long so 'select answer1 from user_answered where supplierid=6262' give the error in sqlplus
<12> how else could i do it
<11> whats the error?
<11> you shouldnt use longs anymore
<14> hrm any of you know of a good string escape routine for vba?
<7> Jarett: Perhaps they're cheap abroad, but in Norway I pay close to $400 for a polarizer
<7> hm UV filter that is
<11> 400 in what currency?
<7> USD
<11> for a cokin uv?
<7> mhm
<11> why?
<7> dunno
<10> it's norway
<11> so you have alot of optics companies located there
<10> my 70-300 lens cost 10K NKr, rougly around $1500
<11> call Farnes Lars in oslo for filter
<12> i didnt setup the db its a old one
<11> uv are like 15$ filters. $25 if large and multicoated :P
<11> the singh ray hilux UV are $160-190 usd those would be insanely expensive over there
<12> ORA-00997: illegal use of LONG datatype is the error
<11> i could get a 70-200 2.8 vr for 1500 ;)
<11> b3nj|mcc, in sqlplus issue this command: set long 50000
<11> then query. if that fails the long is more than 64k and oyu wont be able to use sqlplus to get to it without writting a procedure that wraps the output
<7> ok I have to admit you can get cokin UV filters in plastic for $50
<9> Is this a valid SQL code ? SELECT * FROM (SELECT * FROM T1 LIMIT 0,30) ORDER BY C1
<9> Is this a valid SQL code ? SELECT * FROM (SELECT * FROM T1 LIMIT 0,30) ORDER BY C1 I receive this exception: Invalid query: Every derived table must have its own alias
<9> Can someone help me ?
<14> sdfahg, just guessing, but try SELECT * FROM (SELECT ...) AS TempT2 ORDER BY C1
<9> ok thank Gambit-
Return to
#sql
or
Go to some related
logs:
#politics
#bsd
#computers
#windows
rent a noob bilder
nomine schwarze password
#computers
#worldcup
calls consitution quaint
#hardware
|
|