| |
| |
| |
|
Page: 1 2 3 4
Comments:
<0> TheGamble: yes it would support multiple address books
<1> is each address private to a given address book?
<2> it's somewhat depressing having to go back to work and use mysql 3 after playing around with sql server express these last few months :(
<1> haha
<1> man cb1, you must be too busy to discuss this
<1> l8r
<0> yoyo
<0> yes each address is private to a given address book
<0> also another question... i have ROLES and USERS and USER-ROLE mappings tables. should i make sepearte tables for normal users
<0> and admin users?
<0> b/c the tables are exactly the same
<3> sequel or s-q-l?
<4> hi guys .. small question about an sql statement .. can the LIKE lookup find things with commas in ? ie like `%,%`
<5> Any great sql ebooks you guys would recommend
<6> If you want to create a user table with a login/p***word, which approach could you take to check that table without exposing any connection strings?
<7> navr: encrypt it
<6> encrypt the p***word?
<6> sorry, I am trying to find some good resources on this as I am new, I'll take another look at Google
<6> ah I see, encrypt the string
<6> :)
<6> thanks
<8> one way hash it
<8> don't be stupid
<6> ?? hmmm, ok I will look this up.....
<6> I am just trying to understand the way user logins work with databases,...I ***ume once the user is logged in then a session id is created and returned to that user?
<7> navr: in most cases the user logs him in on every request using cookies
<7> navr: in for example asp.net
<7> navr: in php, the user gets a session id which is stored in a session cookie yeah
<7> navr: for security, youd most likely create the md5 sum of the p***word so that the 'actual' p***word isnt stored anywhere
<6> Lazaron: Excellent thanks, and I guess if an application were accessing it then I would store the md5 sum in a variable somewhere?
<9> how do you go about retrieving something like everything from everything between one numeric value and another in an mssql database ?
<9> like pricerang from to
<9> pricerange even
<10> text : http://msdn2.microsoft.com/en-us/library/ms191311.aspx
<11> i want to create a simple table.. iam using delphi to comunicate with the db file.. and i have gotten quite faar..
<11> problem is that i cant get the data on the form.
<11> made a First_Name, Last_Name char 256 .. and put some data there..
<11> so problem is reading it
<11> SQL error code is -104 Unexpected end of command
<12> UPDATE 'cms_cpg_pictures'
<12> SET 'owner_id' = '5' WHERE 'AID' = '32'
<12> doesnt work
<13> Hi folks, this may seem like a daft question - not even sure it can be done:
<13> SQL Server 2000 SP4: Is it at all possible to change the dbo mapped user?
<13> Wait I think I found what I need: sp_changedbowner
<14> does anybody know how to generate a script with INSERT statements with DB data (to make a backup) in MS SQL Server 2006 / Management Studio ?
<14> *2005
<13> That doesn't seem to have worked :|
<15> hi , guys using msde. http://pastebin.com/635810. I need help with the code between IF/* */ ELSE/* */.
<15> if user1_id =@memberid it should execute the IF() code , otherwise the ELSE code().
<16> ifreezeu you need to put your entire select statement in the if, not just 3 columns
<17> hello
<17> how do i clear results of a query?
<17> lets say in some condition dont want to return any rows
<11> am i not supposed to be able to change a size of a string ?
<11> from 50 to 25 ?
<18> where and how?
<11> its currently size 50.. i want to change it to 25: ALTER TABLE Test ALTER Tst_Str TYPE Char(25);
<11> its a table string
<18> then it wont let you in most dbs if you already have rows with more then 25 in them.
<11> its telling me it has to be least 50... thought i set the rules on how much it has to be ;)
<18> you need to add a new column, populate it with an insert that truncates
<18> drop the old column
<11> k
<19> yar
<19> is anyone alve?
<19> ****ing UPS ground tracking service ****s
<20> y
<20> what are you getting delivered to you?
<19> paintball equipment
<19> some people from my office are going to play on the 22nd... wanna join us?
<20> i fear paintball
<18> hmmm load average of 18.47, 17.41,15.97 on one of my servers :P
<19> you should
<18> amazed it hasnt caught fire
<19> Jarett_: is it a Sun F15k w/64 CPU's?
<19> because, if so, that's no big deal
<19> :-)
<18> 4cpu opteron
<19> 4 real CPU's? or a dual with hyperthreading?
<18> real
<18> hyperthreading is voodoo to make idiots think their intels are better than they are
<19> what if I told you that I worked at Intel's design lab?
<18> i would tell you that it's hella lame and you people should be working on lower power cpus that are faster, and not lame marketing crap like false coring
<19> Pentium M
<18> and i would tell you that within 2-3 years ill have replaced all my intel chips with opterons in my datacenter since intels are too power hungry and pricey for the speed
<19> we don't care about people with no money
<18> it isnt about the money it is about the power and having to replace either the cpu type... or a set of generators and ups
<18> opteron will cut my datacenter power consumption in half.. while giving me 25% more systems
<18> i hope you didnt work on the Itanium project... wouldnt want that fiasco on your resume
<20> i like AMD
<20> Pentium M seems very cool though
<18> i hate my laptop since centrino ****s
<20> why does it ****?
<19> then you shouldn't have bought it
<18> Leap ahead... buy AMD
<20> ?
<19> AMD is run by a crazy texan
<18> im glad to hear that people are returning their intel based laptops in droves
<20> dude
<20> i used to like only Intel
<20> but then tried AMD
<18> since it ums when a core isnt in use
<20> my AMD flies
<20> and runs cool
<18> hums
<20> this proc is like 2.2
<18> 2 of the lame mac lovers i work with were all happy about their dual core monsters until it started to growl at them.. hahaha
<20> i had a dell laptop with 2.8 HT
<20> **** was so slow
<20> i hate that laptop
<20> i wanna break it
<20> i hate dell
<20> they managed to make a 2.8 HT slow....
<20> i think i know how
<19> how?
<20> **** memory, **** mobo, **** harddrive
<20> but expensive cpu
<18> i only like dell for their laptops... since i break keyboards alot
<18> always the right shift and spacebar.
<21> http://pastebin.com/636239
<21> why wouldn't that return all rows in ipAddr with a custId that exists in customer?
<15> hi using msde, http://sql-servers.com/nopaste/?show=503. Based on if (user1_id = @member_id) i want to run If or Else code.
<22> Darren, did my solution work?
<22> I am accessing report manager over the internet, when I click on Report Builder it starts the verification/download process and then says: The remote server returned an error: (401) Unauthorized, what am I likley doing wrong (SQL Server 2005 Reporting Services)
<23> can someone show me a good example of the limit function in sql
<18> avoid limit if possible. learn to subselect or use good clauses
<23> orite
<20> 21:34] <20> guys
<20> [21:34] <20> my system restarts and i get an evenlog entry saying that the shutdown was unexpected
<20> [21:34] <20> yet i don't see memory.dmp
<20> [21:35] <20> how do i find out what the hell is wrong?
<19> wtf is a dmp?
<20> when NT dumps memory before it restarts after BSOD
<19> oh, a dump file
<19> core dump, that is?
<24> hey guys
<25> %Systemoot%\Minidump
<25> Is there something there?
<20> i set it to a complete dump
<20> sec
<25> If you set it to complete there shuld be a memory.dmp ... perhaps it is flagged as a protected OS file and you need to turn off your filter to see it?
<20> nope
<20> i have a feeling it wasn't a BSOD
<20> but i wonder wtf is it restarting for
<26> http://rafb.net/paste/results/hxWj0173.html --mysql
<26> i need the date (p.date) that matches MAX(p.phase) as phaze
<19> thun: here's a hint... subselect's
Return to
#sql
or
Go to some related
logs:
#linuxhelp
#windows
#sex
#politics
#politics
#delphi
Maxtor 1394 Storage Front Panel* Driver issue
#beginner
Wonderbah
#sql
|
|