| |
| |
| |
|
Page: 1 2 3 4 5
Comments:
<0> blah
<0> has anyone (recently) taken the MS course 2733 "Updating your DBA Skills to 2005"?
<0> Beuller?
<1> what's the best way to keep the integrity of a value when u update/insert
<2> with shields raised
<2> bracing for impact
<1> update tbl set fld = ['a23ds'sdfasd'] where blah=blah ?
<2> wtf
<2> isnt there an option
<2> to like cascade updates on FK/PK ?
<2> course you didnt even state
<2> what db ur using
<2> and your query seems to have nothing to do with what your original question appearedt o be about
<1> oops, bad questioning
<1> i have this crazy "credit card encrypted" value that won't seem to allow me to update nor insert in to ms sql db
<2> varbinary?
<2> i've encrypted data numerous times
<2> and been able to insert it into db fine
<1> example: set cc_num = '''k]FqZ 1y'
<2> you should be using parameters btw
<2> ypou should NOT
<2> be usimng a direct sql
<2> e..g
<2> UPDATE tablename set field= @field where condition=@condition
<1> ic
<1> blahhh i'm screwed, gotta rebuild the whole mechanism to do adodb command with stored proc
<1> since u're suggestin to use @value thingie hehe
<2> umm
<2> you dont have to switch to stored procedures
<2> the sql that i provided
<2> will work just fine
<2> without being a stored procedure
<2> they are called parameterized queries
<1> yeah but how do i pump the @field into my inline sql
<2> and they are recommended practice
<2> its not
<2> you add it as a parameter
<2> what is your lamgiage?
<2> langjuage even
<2> languabve
<2> language
<2> gg
<1> vb6
<2> do you have sample connection code
<2> to connect to a db?
<1> there's a stupid dll that does all the db conn and execute
<1> i'm callin it to decrypt and encrypt my cc
<1> but ****... after encrypt it... i can't update it back....to SOME of the cc
<1> due to its funk char
<2> well
<2> #1
<2> thats why you used parameterized queries
<2> it eliminates that problem
<1> my coworker suggest do manual adodb with param like u did
<2> #2 - there are methods of storing data in binary safe manner through non-binary safe
<1> i came here to hear what u guys have to say :)))
<2> e.g. you could base64 the encryption
<1> umm..
<2> ?
<1> reading... and thinkin...
<2> [Arrakis] makes no sense to me
<2> [Arrakis] try obtaining a newer version of dreamweaver
<2> [Arrakis] they are at mx
<2> [Arrakis] 2004 or 2005
<2> <marsh> just for you then i will go out and buy a copy
<2> <marsh> thanx for the advice
<2> *** marsh (~pearl@
<3> they ar ebeyond mx
<4> wtf ...
<3> dreamweaver 8 isnt even labeled Mx. I cant wait for Adobe Dreamweaver 9 ;)
<4> adobe's going to buy macromedia?
<3> they already did
<4> well **** ...
<2> there wont be much difference
<3> and already rebranded some of the software. like lighttable
<2> the most that might happen is
<2> that they will start changing dreamweavers shortcut keys
<2> so control alt s
<2> will nbow do some random thing
<2> or not work at all
<4> i hope adobe does'nt make dreamweaver "Adobe"-like ;)
<2> even though in x amount of appliations
<2> use it to save all documents
<3> and they will take the CMS and server software and make pdf apps around it
<2> zoul
<2> i dont think adobe understand how to leave something alone
<2> but overall adobe and macromeda are a match made in heaven
<3> as long as they kill flash, ill be happy
<2> they wont kill it
<2> but
<2> it will take 70 seconds to load up
<2> and people will still use it
<2> because the only alternative will be provided by ms
<2> and everybody "hates" ms
<4> yeah <I love how adobe has acroread.exe loaded in the system, and acrobats till takes forever to load up inside of IE or on the desktop
<2> kekekke
<2> or how adobe photoshop
<2> which does really nothing on load
<2> takes 1 minute to laod
<2> while vs.net
<2> a similar app that does nothing
<2> and yet has numerous plugins and other crapit has to get ready
<2> opens up in under 1 second
<2> on the same exact machine
<4> vs.net does not load in under a second, haha
<2> does here
<4> photoshop and vs.net load in the same time on my machine
<2> i click the vs 2k5 icon
<2> and bam
<2> it loads up
<4> for z in *.part01.rar; do unrar x "$z": done;
<4> wtf is wrong with that ... ?
<1> Arrakis, bahh i'm tired tryin.. imma do manual adodb command with param to end this nightmare
<2> umm
<2> shouldnt that rar;
<3> zoul, how many part01 would you have?
<2> be a : ?
<4> Jarett_: any number of them ...
<4> it drops me to a ">" prompt, expecting me to finish the commnad
<2> ....
<3> rar should automatically handle split files anf you just unrar the original
<3> "$z": shoudl be "$z";
<4> Jarett_: ... hence the *.part01.rar portion of the statement ... I'm extracting numerous rar 'archives'
<4> haha, oops ...
<2> your query makes no sense
<2> you say for ;
<3> or just use find ;) find . -name "*.rar" -exec unrar x {} \;
<2> now in most C/perl style languages
<2> that means that that for loop does nothing
<4> Arrakis: it's BASH
<5> Jarett_: it does under windows
<2> right but it should still
<4> Arrakis: it's a BASH statement, it uses ';" to finish lines, not 'statements'
<2> be for z in *.part01.rar ; do unrar x "$z" ______ : done;
<2> one of those needs to be fixed :P
<4> for z in *.txt; do type $z; done; # type's every file in `pwd` to the screen matching *.txt
<4> Arrakis: I had a ':' and not a ';' ... otherwise, the statement is right
<2> well thats what i was pointing out :p
<2> i saw the : and instnatly thought to some old arcane style of spearating
<4> *.part01.rar is the naming convention for the 'first' part of a multi-part archive ... used to be *.rar, but now it's *.part01.rar
<2> so when i saw the ; after for i was like hmm
<4> was just a dumb typo that i didn't see ...
<0> umm
<0> rar knows how to handle split files
<0> just call the first file and the switch for multi-file archive...
<0> wtf are you doing a for loop for?
<6> hi...using SQL Server 2000 and in Query Analyzer i'm trying to p*** the results of a query to a stored proc that takes two params. Example: EXEC sp_writetext (select 'N',p_desc from stdp)
<6> first is that do-able? I haven't seen anything on it...everything I've looked up talks about p***ing absolutes to a proc, not dynamic data
<7> No.
<6> thanks, cursor my only option?
<7> You can define a variable prior, select the values from the table into the variable and then p*** the variable.
Return to
#sql
or
Go to some related
logs:
nevaryzarc
#beginner
#nhl
HaLLuCiN0
shietzer
#beginner
ahas hacker
#visualbasic
#computers
#politics
|
|