| |
| |
| |
|
Page: 1 2 3 4 5
Comments:
<0> in life you 1. look very good to the eyes 2. are very smart 3. have lots of money
<0> if none of these are true you will go no where
<1> i have pretty eyes :P does that count?
<1> :D
<0> o
<0> no
<2> send me a picture :)
<0> ...
<0> TheGamble www.google.com and look for 'eyes'
<0> google images
<0> wierdo heh
<2> heh
<2> only kidding :(
<2> daniela--, are you expecting to see little "sub-groups" in the rowset?
<1> isn't that whaT you said?
<1> [23:39] <8> order by orders the data
<1> [23:39] <8> and group by singles it out by groups
<1> Arrakis
<2> I said nothing (check your logs)
<2> what that means is the detail that comprises the groups is not shown; the data is "grouped" and the groups are shown
<2> "rolled up" if you will
<2> so if you have 3 order rows for customer 'A', one for $10, one for $20, and one for $30, and you SELECT CustomerID, SUM(OrderAmount) FROM Orders GROUP BY CustomerID you get 1 row; 'A', $50
<1> let me check that
<3> $60 :p
<2> you know what i mean :)
<2> the point is, you only see the customer 'A' represented once, since that is what I GROUPed by
<2> If you add more columns to GROUP BY, you'll get finer and finer 'groups'
<2> but you will never see the detail unless you group by all the columns, which would defeat the purpose
<1> ...
<3> u dont understand it:P?
<1> no and this is a sure sign I should go to sleep already
<1> thanks for ***istance, though
<1> night
<2> :(
<2> I think n00bs expect GROUP BY to have little subtotals for each group, I really do
<4> can someone help me with making a better connection to access database and terminating the connections http://pastebin.com/623915
<4> i was told to use sql server instead but i have no idea where to begin http://piratez.ath.cx/temp/CT-652538-AEBW%20Magma%20Support%20Request%20-%20VWS%20Access%20DB%20error.txt
<4> help?
<2> first off, chill; take a pill if you have to, but chill
<2> second, what do you want us to do with 910 lines of HTML and JavaScript?
<4> just have a look at the connecton to the database, i was told to use ole db instead of the current method but i have no idea where to begin
<2> you running out of connections?
<4> on www.cptn.com
<4> yep
<4> support said it was a limitation of access driver ;]
<2> well, for one thing, I don't see any objConn.Close() in your code anywhere
<2> nor Set objConn = Nothing
<2> when you are finished with the connection, close it and set it to nothing
<3> why the **** would you need more than 910 connections
<2> who said he had 910 connections?
<3> ahhh
<3> lol
<4> so at the end of the last connection set it to nothing and close it
<3> misread
<2> Piratez, not at the end, after you're done with the connection *as soon* as you're done with it
<4> http://pastebin.com/623932 so in something like this where would i close it
<0> rtfm
<4> thats just the connection portion of it
<0> at the point where you don't need to send or recieve any more data
<0> you are DONE der
<2> also, this syntax is poor practice: objConn = "driver={Microsoft Access Driver (*.mdb)};"
<2> use objConn.ConnectionString = "blah"
<4> can can i change the access driver to an ole db driver?
<4> that was also recommended
<2> yes
<2> Provider=Microsoft.Jet.OLEDB.4.0
<4> objConn.ConnectionString = "driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath(dbFile) & ";"
<4> so instead of driver=
<2> yes
<4> ah
<4> thank u
<2> you're welcome
<2> and instead of dbq, use Data Source=
<2> check www.connectionstrings.com for full examples
<4> brilliant resource, thanks a lot
<2> you're welcome
<5> evening all
<2> evening
<6> Are general dbase design questions accepted here or just the coding for doing queries etc? Have a quick question regarding a database I'm creating
<7> depends
<5> ask the question - you may or may not get kicked
<2> heh
<2> roll the #sql dice
<7> if its mysql related... you dont bother
<2> Props to PJStyles for at least asking about the conventions
<7> nah... thats an ask to ask thing... and thats bad
<2> see that's where I get a little pissed about IRC in general
<2> to avoid an insta-kick, he tried to clarify the vague channel rules
<7> Ive seen nothing but "can i ask oracle questions here?" in #oracle for weeks
<2> now *that* is hosed
<7> and people leave if no one answers
<2> but this is more of a relational theory issue apparently, and he *could* get flamed for it not being an "SQL" question
<2> relational != sql
<7> if they dont have the desire or persistence to actually ask, it isnt worth answering
<2> yeah, he's been silent for 8 minutes now :(
<8> huh?
<5> yeah, where's the ****ing question, PJStyles?
<8> OUT WITH TEH MUTHA ****IN QUEStION
<6> sorry... had to attend to my daughter...
<6> back now
<6> I'm familiar with relational dbases but have a question that has me stumped a little bit...
<6> I'm starting up my own online poker store and I'm running into a situation where I'm not sure which direction I should go with the database design... I have different categories of products ie: chips, cases, cards, sets etc. However, within the chips category I'll not only have various manufacturers, but each manufacturer will have chips with different colors and weights. What's the best way to go about incorporating that into the db?
<7> are you just selling? or playing games too?
<6> just selling poker supplies...
<7> Why are you recreating the wheel?
<7> www.oscommerce.com
<7> it supports all those.
<7> and use STS for the template system.
<6> Yeah... only thing is I'm using coldfusion to design my website... hmm... wonder if I could plug in the oscommerce cart
<7> wow thats horrible
<7> let cold fusion die
<7> get a 3rd party hoster, or run up php and apache 2. done.
<6> I love coldfusion... so quick to implement simple solutions...works for me.. I'm not about to get into the arguments for or against using it... quite familiar with that...
<7> spend time on the graphics and modules youll need
<7> so quick ti impliment unsecure solutions
<6> unsecure? seem a bit uninformed about coldfusion but I respect your opinion... again not going to get into that
<7> ive been using it since 1996, how about you?
<6> Since about 94
<6> lol
<7> its sort of like seeing people use C for websites still.. not knowing there are better ways to do it.
<7> or perl.
<6> to each their own
<7> Time to move on.
<6> if I knew PHP and could implement the solution in a timely manner, I would...but I don't and really don't feel like learning it given I don't code for a living...
<7> you can drop oscommerce into place and have a running store within 4 hours of tuning
<7> very little coding needed.
<6> I'll have to look it over...
<7> just like there are plenty of prebuilt carts for every language
<6> what are the basic requirements to get it going?
<7> even CF. dont recreate the wheel
<6> yeah...found a good coldfusion one but it's $299... was hoping to find a free cf cart but I won't be a stickler if it can do the job for that price
<7> apache, php (non safe mode)
<7> just depends what modules you want.. like automatic thumbnail resizing and all that
<7> if you use STS template engine, you just make 1 or 2 main templates and add in the keywords to show the blocks
<6> I see...
<9> jarett
<9> i got an email
<9> about some Oracle position
<9> 23 motnhs
<9> do you want a copy of that?
<7> no
<9> :)
<7> im living rent free right now :P moving would be a pay decrease
<5> so - what was the question from PJStyles again?
<6> lol... can't even remember now :) lol
<7> how do i recreate the wheel?
<2> unless the new engagement more than compensated
<2> rent free is only worth so much
<9> Jaret: in NY
<7> nyc?
<9> yea
Return to
#sql
or
Go to some related
logs:
m90 pc beep stop
#debian
#computers
hacking muvo v200
brigitte bardote films
#windows
#beginner
#winvista
#nhl
#goal
|
|