| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8
Comments:
<0> This is why I didn't say it at first. So MySQL doesn't support UNION?
<1> go ask in #mysql
<0> Was just about to
<0> Thanks anyway :)
<1> depends on the version
<1> which is one reason we don't support it
<0> (Didn't realize channel existed - Have had advice from here before, so I came here first)
<1> don't let the door hit your arse on the way out
<2> ahh
<3> <trffar fr distans nr=1> is that a vailed xml code?
<4> look at xml/xhtml specs
<3> chen`chen haha. dont like the message before?
<4> why dont u just try
<3> i ask y.. and you do not replay :(
<3> i have the xml bible but i am to layz to search for a answer
<3> chen`chen what happend?
<5> 36C is cold?
<5> woops I was scrolled way up without knowing
<6> is there a boolean type in oracle?
<6> hello?
<7> *ello*... *llo* ... *o* ... *o* ......
<8> dunno
<8> to both your questions
<4> hi for ms sql 2005 to output xml select result, is the FOR XML clause still needed ?
<8> yes
<4> thank u lvk
<8> you got more options in 2005 than 2000 but you still need it
<4> great, thanks honey
<9> LVK, you have much experience with indexed views in sqlserver
<9> ?
<4> have u played around with for xml explicit? i have this [Name!1!ID] . but i'd like to give it a namespace, like [X:Name!1!ID] but i get undeclared prefix
<8> dfworking: not as such, no
<9> ok
<8> chen`chen: I don't use the XML support in SQL Server
<4> alrite
<10> hi all
<4> hi
<11> how do you restrict a select statement so that it returns only a single row ?
<5> select top 1 ...
<12> anyone know if there is a SQL way of choosing ALL but the first record.
<12> like the opposite to Top
<9> why not just get all and just not use the first record when you're iterating output
<12> its a report, and I dont know how to do that.
<9> it is possible to do what you're saying, which db
<12> access
<12> 2k3
<9> well, you'll have to test:
<12> ok
<9> SELECT t1.* FROM table t1 WHERE t1.id NOT IN (SELECT TOP 1 t2.id FROM table t2 WHERE t2.blah = 'hello') AND t1.blah = 'hello'
<12> (Also I suppose I could reverse the order and then take the top n=count-1)
<12> ahh, I see what you did there
<9> only to reverse it again? i wouldn't, but you could yes
<9> i used IN so that you could change the TOP to exclude the first 3 rows if you wanted
<9> obviously, you'll need to add the sort in the query
<9> both
<12> yar
<12> oh pants
<12> I cant use "top" inside a pivot table apparently
<12> unless I do something reaaaaaally cheeky....
<12> triple embeeded statements.... nom nom nom nom
<12> crap.... turns out you cant embed a pivot table either...
<12> OR it gets confused by the second embedded sql statement.
<12> Select fizzlepop.* from [select wizzlpop.* from [select table.* from table where table.id=1]. as wizzlepop]. as fizzlepop
<12> as an eg
<8> are you using [?
<8> [..]
<13> so i've got a sorta-SQL question...
<13> i need a database for inventory, order-taking, order status and sales stats. inventory and order status has already been done in MySQL, with PHP/HTML frontends.
<13> we're needing to replace our current order-taking FoxPro-based app with an SQL db... probably MySQL, since that's what i'm familiar with.
<13> but i'm wondering what would be good for a frontend...
<8> is only internal people going to be using it?
<8> ie. people on your lan
<13> PHP/HTML works i guess, but that leaves 3 critical apps on the server (MySQL, PHP, Apache) to "break". i'd rather have everything but the db be client-based.
<13> yes, internally only.
<8> my preference is always a windows application if it can be done
<8> people always request more functionality than what a web application can provide (easily)
<13> yeah.
<13> i know it'd be a lot of work for me to attempt to do it web-based... target is within 1 week, but i know i'd need at least 2 to do it myself, so i'm gonna have to find someone to do it...
<13> i just need to know what i want, first. :P
<13> i suppose it doesn't really matter what language it is, pretty much all the major ones will provide functionality for simple tasks with a remote db?
<13> C++ and VB come to mind...
<13> Java being a maybe.
<8> well, that depends on a lot of questions
<8> 1. will you (your company) build it yourself internally or just buy the necessary program from someone (ie. they make it and sell it to you)
<8> 2. will you want to own the source or bug the author for updates/bugfixes?
<8> 3. will you want to continue development on it yourself?
<8> if yes on own source, or develop yourself, or develop internally, then go with what you can
<8> otherwise leave it to the author
<8> personally I would use C# and .NET 2.0 and Visual Studio 2005
<14> hi there - wrong channel I think but can anyone here recommend a channel for asking about accessing data in an SqlDataSource in .net 2.0 from code (not bound to a control)?
<13> 1) buy it from someone 2) own source would be prefered, unless it's an established, reliable author that can be counted on for updates. 3) no, i'm only personally somewhat familiar with web-based programming.
<13> what is the learning curve on those to be able to turn out a program that'll do simple db manipulation?
<8> > 1 week to be honest
<14> pacmanfan: vis studio has some excellent tutorials in it that leads you through lots of simple examples
<13> probably not worth my time, unless an author that knows their stuff is going to be charging thousands for what would probably be about a day's work.
<8> yeah, but the thing is, you pay him for doing it in a day :)
<8> ie. you can spend 1 month on it, or pay him to spend one day
<13> yeah.
<8> it's not what his time is worth, it's what yours is
<13> i'm just saying... $5000 is out of budget, $1000 isn't.
<13> i haven't an idea what the going rate is.
<14> :P
<14> interested?
<14> ;)
<13> for that matter, i don't know where to find an author. :P
<13> $2000/day? eek :P
<14> yeh
<14> for
<14> erm
<14> well if a ferrari costs say 100,000, that means 50 days
<14> hows that sound :D
<13> heh
<13> sounds great for somebody. :)
<14> pacmanfan: consultancy, i bet your looking at about 30-40 $ an hour for someone who is 1/2 decent
<14> probably more
<13> consultancy?
<14> yeh external person to do work
<13> k.
<13> that's probably manageable.
<14> do you also need someone to set up all your hardware, software, server, do maintenence, upgrades, backups, etc.etc.?
<13> i guess i need to get in contact one with a feature list, and get an estimate?
<13> already running Win2k3 server... backups etc are covered.
<14> yeh but together a brief and get some quotes in
<13> got any sample briefs sitting around? :o
<13> where do i look for programmers? heh
<14> there are some web sites around where people hawk their skills, thoguh I couldtn tell you which ones
<14> you could also look at other similar web sites you like the look of
<13> alrighty, i'll dig...
<14> see if you can spot who made it
<14> a fair few have `designed by` bits hidden somewhere
<13> don't need any web design done. i've done plenty of that.
<14> well you get what I mean :)
<13> just an application/interface for a db frontend.
<14> I dont supose anyone can help me with my .net issue?
<13> heh, sorry
<14> pacmanfan: you could aalways just spend a week messing around with VS in your spare time, see how youg et on with it
<14> if you do do it yourself, least you can expand on it in the future with ease when you get the hang of things
<13> except it'd be nice to have it done in a week, and it needs to be fairly bulletproof from the get-go.
<13> although there certainly does need to be future expansion.
<14> if its done in .net 2 thats a pretty good way of bullet proofing things quickyl as it does so much checking and stuff for you
<13> i might give it a shot for one DAY, and see how i get along.
<13> hmm, ok
<13> so what's exactly required... just get Visual Studio and run with it?
<13> and i'd be coding .NET 2.0 and C#?
<14> i was going through its tutorials a week ago, I had a fulyl authenticated database with funky master pages, personalised accounts and data integration with a backend db (all done as a test) in about 3 days
<8> get visual C# Express, it's free and it uses C# and .NET
<14> c# or .net vb, wahtever works for you :0
<14> :)
<13> ok
Return to
#sql
or
Go to some related
logs:
#goal
#politics
#politics
chloretrimiton
#beginner
#delphi
movies of denzyl washington
#beginner
#beginner
#computers
|
|