| |
| |
| |
|
Page: 1 2
Comments:
<0> nack
<0> back too
<1> sup
<1> is it possible to have record copies from one table to another by a sql insert and select? and in the same, remap the fields and add empty strings too?
<2> sure
<1> smthg like: insert into tableA (id,title,text) values select ID,t,'' from tableB ?
<2> along those lines, yep
<1> erm, sorry? along those lines? dont understand that ;)
<2> I mean that isn't it exactly, but close enough that google and f1 should get you from that to the real thing
<2> what db?
<1> mysql
<2> good luck
<1> hehe no god?
<1> good?
<1> any URL pointment?
<0> hrm, is there a way in VB6 to get the names of all the properties/methods in an object ...
<0> kind of like how in .NET you can peek at an object to see what properties/methods it contains, as well as reference them by 'string' name with something like obj.Properties.Item("ConnectionString") = "Server=localhost;";
<3> hm
<3> I want to say yes given that it's stored in a typelibrary, at least for public COM objects, but I am not aware of the method
<3> Defintely not for private objects.
<0> hrm ...
<3> .NET and Java have the advantage of storing a crapload of metadata about each type due to the deferred compilation methods.
<0> yeah ...
<0> I'd like to be able to do something similiar to .net's reflection ... but in VB6
<0> I'm thinking I might just have to write alot of tedius code by hand ...
<3> Reflection doesn't exist in VB6
<0> create a function for each object type, that is aware of the objects properties ... hard coded into it ...
<3> Much of the code is compiled completely away.
<0> Halo_Four yeah, I know it doesn't ... but, if i can look at the objects properties, by name ...
<0> I can do something similiar
<0> an eval() option would be nice, running inline code thats dynamic ...
<0> similiar to set @sql = 'select * from tbl'; exec @sql;
<3> You can bring in the VBScript library and do that
<0> it's a standard lib I'm working with, DTSObject Reference Library ...
<3> But VB6 compiles to x86 and the majority of metadata, including private function names and variables, disappear
<0> so if I have an object in my VB app, called objTask for example, and I create a script instance, and execute the dynamic script within the app, would my script have access to the vb apps objects?
<0> JScript has an eval() routine
<3> I ***ume that you can p*** an object to the script libraries as a parameter, but I honestly don't know.
<3> So does VBScript
<4> mssql, im joining two tables and i want to return records where each table contains a record for the join condition
<0> The code p***ed to the eval method is executed in the same context as the call to the eval method.
<0> from the msdn for the jscript eval() method
<0> tapped "from a inner join b on a.value = b.value"
<0> that'll only return records where a match exists in both a and b
<3> zoul: Sure, if JScript calls eval() containing JScript. Ballgame changes completely when a native language is used.
<0> Halo_Four, hrm ... but i could create my library in VB ...compile as an activex dll ...
<0> then write my dynamic property changing code in VBS ...
<3> Sure
<0> then execute a VBS file, rather then a VB6 EXE
<0> making a pseudo-reflection system ... yes?
<3> Well, a late-bound system, sure.
<0> just have an error trap, that prevents the script from run-time errors ... in the event the property doesn't exist
<5> @%
<6> learnsql = http://sqlzoo.net/ http://sqlcourse.com http://sqlcourse2.com ,this is my way of telling you that you make no sense
<0> so if I have an xml node like: <component type='CreateProcess'><terminateOnTimeout>1</terminateOnTimeout></component>
<0> and I p*** each child node in as a 'property' of my 'Task' object ... and just run an eval() that does eval("objMyTask." & node.Name & " = " & Node.Value) ... it'd be pseudo-reflection ;)
<0> then objMyTask in the VBS script would be given the appropriate values ... and can be p***ed into the DTS object as is ...
<0> reducing the overall amount of code I have to write ... so I don't have to write a long *** case statement ... "select case node.name: case 'terminateOnTimeout': objMyTask.TerminateOnTimeOut = node.Value: end select" ... for example, for each possibly property type ...
<3> I think you could do that
<5> @%
<6> religion = <Darken> religion was written in sql and regex
<3> Hardly, I can understand SQL and regex.
<7> <3 sql2k install... "Click Finish to Begin..."
<8> lmao
<9> hey
<9> can i ask a question?
<9> about mySQL
<9> it's for my homework
<10> bout ****ing time
<11> wth. i didn';t know that "zoul" == "moz"...
<10> :)
<10> what do you think "z" in MoZ stands for? :)
<11> man.. MOz, you really got me.. Ah.. MoZoul?
<11> as in module ?
<10> uhm ... as in 'Master of Zoul' ;)
<11> or "M"aster "o"f "Z"oul?
<10> and my hostmask is zoul@alt-bin.will.never.unban.us ... heh ... note the 'zoul' ;)
<12> if i want to delete pkCATEGORY_ID from table CATEGORY, how do i remove all subcategories from table SUBCATEGORY with MAIN_CAT=pkCATEGORY_ID
<13> hi
<13> can anyone help?
<13> ive got a question. i designing a transaction database and i need to know how many tables i need to withdrawn money from the transaction table
<13> does it take two tables? one table for request and one for batch process?
<11> dang it's 3:34am and i am still at work w00t
<11> great to be alive..
<13> hi
<13> can anyone help?
<13> i need some help with transaction tables
<14> Hey all - Join OUR Austnet Community - type (no space before server) / server us.austnet.org or au.austnet.org or sg.austnet.org - We are VOTED as number 1.. MOST stable Irc servers on this planet.. TRY IT NOW!! Its K00L... ^_^,.,.,.,...mmwah,,..see ya there ,,,.
<14> Hey all - Join OUR Austnet Community - type (no space before server) / server us.austnet.org or au.austnet.org or sg.austnet.org - We are VOTED as number 1.. MOST stable Irc servers on this planet.. TRY IT NOW!! Its K00L... ^_^,.,.,.,...mmwah,,..see ya there ,,,...........
<14> Hey all - Join OUR Austnet Community - type (no space before server) / server us.austnet.org or au.austnet.org or sg.austnet.org - We are VOTED as number 1.. MOST stable Irc servers on this planet.. TRY IT NOW!! Its K00L... ^_^,.,.,.,...mmwah,,..see ya there ,,,............
<14> Hey all - Join OUR Austnet Community - type (no space before server) / server us.austnet.org or au.austnet.org or sg.austnet.org - We are VOTED as number 1.. MOST stable Irc servers on this planet.. TRY IT NOW!! Its K00L... ^_^,.,.,.,...mmwah,,..see ya there ,,,.............
<14> Hey all - Join OUR Austnet Community - type (no space before server) / server us.austnet.org or au.austnet.org or sg.austnet.org - We are VOTED as number 1.. MOST stable Irc servers on this planet.. TRY IT NOW!! Its K00L... ^_^,.,.,.,...mmwah,,..see ya there ,,,..............
<14> Hey all - Join OUR Austnet Community - type (no space before server) / server us.austnet.org or au.austnet.org or sg.austnet.org - We are VOTED as number 1.. MOST stable Irc servers on this planet.. TRY IT NOW!! Its K00L... ^_^,.,.,.,...mmwah,,..see ya there ,,,...............
<14> Hey all - Join OUR Austnet Community - type (no space before server) / server us.austnet.org or au.austnet.org or sg.austnet.org - We are VOTED as number 1.. MOST stable Irc servers on this planet.. TRY IT NOW!! Its K00L... ^_^,.,.,.,...mmwah,,..see ya there ,,,................
<14> Hey all - Join OUR Austnet Community - type (no space before server) / server us.austnet.org or au.austnet.org or sg.austnet.org - We are VOTED as number 1.. MOST stable Irc servers on this planet.. TRY IT NOW!! Its K00L... ^_^,.,.,.,...mmwah,,..see ya there ,,,.................
<14> Hey all - Join OUR Austnet Community - type (no space before server) / server us.austnet.org or au.austnet.org or sg.austnet.org - We are VOTED as number 1.. MOST stable Irc servers on this planet.. TRY IT NOW!! Its K00L... ^_^,.,.,.,...mmwah,,..see ya there ,,,..................
<14> Hey all - Join OUR Austnet Community - type (no space before server) / server us.austnet.org or au.austnet.org or sg.austnet.org - We are VOTED as number 1.. MOST stable Irc servers on this planet.. TRY IT NOW!! Its K00L... ^_^,.,.,.,...mmwah,,..see ya there ,,,...................
<14> Hey all - Join OUR Austnet Community - type (no space before server) / server us.austnet.org or au.austnet.org or sg.austnet.org - We are VOTED as number 1.. MOST stable Irc servers on this planet.. TRY IT NOW!! Its K00L... ^_^,.,.,.,...mmwah,,..see ya there ,,,..........................................
<14> Hey all - Join OUR Austnet Community - type (no space before server) / server us.austnet.org or au.austnet.org or sg.austnet.org - We are VOTED as number 1.. MOST stable Irc servers on this planet.. TRY IT NOW!! Its K00L... ^_^,.,.,.,...mmwah,,..see ya there ,,,..,.,.
<14> Hey all - Join OUR Austnet Community - type (no space before server) / server us.austnet.org or au.austnet.org or sg.austnet.org - We are VOTED as number 1.. MOST stable Irc servers on this planet.. TRY IT NOW!! Its K00L... ^_^,.,.,.,...mmwah,,..see ya there ,,,..,.,..
<14> Hey all - Join OUR Austnet Community - type (no space before server) / server us.austnet.org or au.austnet.org or sg.austnet.org - We are VOTED as number 1.. MOST stable Irc servers on this planet.. TRY IT NOW!! Its K00L... ^_^,.,.,.,...mmwah,,..see ya there ,,,..,.,...
<14> Hey all - Join OUR Austnet Community - type (no space before server) / server us.austnet.org or au.austnet.org or sg.austnet.org - We are VOTED as number 1.. MOST stable Irc servers on this planet.. TRY IT NOW!! Its K00L... ^_^,.,.,.,...mmwah,,..see ya there ,,,..,.,....
<14> Hey all - Join OUR Austnet Community - type (no space before server) / server us.austnet.org or au.austnet.org or sg.austnet.org - We are VOTED as number 1.. MOST stable Irc servers on this planet.. TRY IT NOW!! Its K00L... ^_^,.,.,.,...mmwah,,..see ya there ,,,..,.,.....
<14> Hey all - Join OUR Austnet Community - type (no space before server) / server us.austnet.org or au.austnet.org or sg.austnet.org - We are VOTED as number 1.. MOST stable Irc servers on this planet.. TRY IT NOW!! Its K00L... ^_^,.,.,.,...mmwah,,..see ya there ,,,..,.,......
<14> Hey all - Join OUR Austnet Community - type (no space before server) / server us.austnet.org or au.austnet.org or sg.austnet.org - We are VOTED as number 1.. MOST stable Irc servers on this planet.. TRY IT NOW!! Its K00L... ^_^,.,.,.,...mmwah,,..see ya there ,,,..,.,.......
<14> Hey all - Join OUR Austnet Community - type (no space before server) / server us.austnet.org or au.austnet.org or sg.austnet.org - We are VOTED as number 1.. MOST stable Irc servers on this planet.. TRY IT NOW!! Its K00L... ^_^,.,.,.,...mmwah,,..see ya there ,,,..,.,.............
<14> Hey all - Join OUR Austnet Community - type (no space before server) / server us.austnet.org or au.austnet.org or sg.austnet.org - We are VOTED as number 1.. MOST stable Irc servers on this planet.. TRY IT NOW!! Its K00L... ^_^,.,.,.,...mmwah,,..see ya there ,,,..,.,..............
<14> Hey all - Join OUR Austnet Community - type (no space before server) / server us.austnet.org or au.austnet.org or sg.austnet.org - We are VOTED as number 1.. MOST stable Irc servers on this planet.. TRY IT NOW!! Its K00L... ^_^,.,.,.,...mmwah,,..see ya there ,,,,.
<14> Hey all - Join OUR Austnet Community - type (no space before server) / server us.austnet.org or au.austnet.org or sg.austnet.org - We are VOTED as number 1.. MOST stable Irc servers on this planet.. TRY IT NOW!! Its K00L... ^_^,.,.,.,...mmwah,,..see ya there ,,,,.,
<14> Hey all - Join OUR Austnet Community - type (no space before server) / server us.austnet.org or au.austnet.org or sg.austnet.org - We are VOTED as number 1.. MOST stable Irc servers on this planet.. TRY IT NOW!! Its K00L... ^_^,.,.,.,...mmwah,,..see ya there ,,,,.,,
<14> Hey all - Join OUR Austnet Community - type (no space before server) / server us.austnet.org or au.austnet.org or sg.austnet.org - We are VOTED as number 1.. MOST stable Irc servers on this planet.. TRY IT NOW!! Its K00L... ^_^,.,.,.,...mmwah,,..see ya there ,,,,.,,,
<14> Hey all - Join OUR Austnet Community - type (no space before server) / server us.austnet.org or au.austnet.org or sg.austnet.org - We are VOTED as number 1.. MOST stable Irc servers on this planet.. TRY IT NOW!! Its K00L... ^_^,.,.,.,...mmwah,,..see ya there ,,,,.,,,,
<14> Hey all - Join OUR Austnet Community - type (no space before server) / server us.austnet.org or au.austnet.org or sg.austnet.org - We are VOTED as number 1.. MOST stable Irc servers on this planet.. TRY IT NOW!! Its K00L... ^_^,.,.,.,...mmwah,,..see ya there ,,,,.,,,,,
<14> Hey all - Join OUR Austnet Community - type (no space before server) / server us.austnet.org or au.austnet.org or sg.austnet.org - We are VOTED as number 1.. MOST stable Irc servers on this planet.. TRY IT NOW!! Its K00L... ^_^,.,.,.,...mmwah,,..see ya there ,,,,.,,,,,,
<14> Hey all - Join OUR Austnet Community - type (no space before server) / server us.austnet.org or au.austnet.org or sg.austnet.org - We are VOTED as number 1.. MOST stable Irc servers on this planet.. TRY IT NOW!! Its K00L... ^_^,.,.,.,...mmwah,,..see ya there ,,,,.,,,,,,,
<14> Hey all - Join OUR Austnet Community - type (no space before server) / server us.austnet.org or au.austnet.org or sg.austnet.org - We are VOTED as number 1.. MOST stable Irc servers on this planet.. TRY IT NOW!! Its K00L... ^_^,.,.,.,...mmwah,,..see ya there ,,,,.,,,,,,,,
<11> gosh darn it i was afraid of typing
<11> MoZ:: get your *** up in here already..
<11> somone ban his *** or something
<15> morning
<11> morning
<3> http://www.microsoft.com/downloads/details.aspx?familyid=2EC9E842-40BE-4321-9B56-92FD3860FB32&displaylang=en
<3> Map of the system views in SQL2005
<16> http://www.trofeoasi.altervista.org
<17> interesting
<15> afternoon all
<15> hey _MoZ
<18> is it possible to combine a MAX satement inside a INSERT INTO statement? I tried as followed: INSERT INTO galleries(title, date, index) VALUES ('val2','val1',(SELECT MAX(index) FROM galleries))
<15> it is possible, but you have to do the whole 'values' part as the select
<19> use insert...select instead?
<18> ?
<15> all depending, of course, on whcih rdbms this is for... which you've not said yet
<18> its Access
<18> with asp.net
<10> d2d_w0rk: ?
<15> insert into table (field_list) select 'val1'..., max(x) from other_table
<15> is the basic structure... the ms-access documentation will help with any other details on it's use
<18> ok thanx
<20> I have a question... ;) I'm creating a client table which have a relationship with an agreementstable (one client can have many agreements). Now, I need to list those agreements on an ASP page. How should the sql string look like?
<21> basically: select * from agreements a join clients c on c.clientid = a.agreementid where c.clientid = whateverclient
<20> ok I'll try
<21> Look up select and join in your docs.
<18> GuntherX- I tried 'INSERT INTO galleries(title, date, index) SELECT 'val1','val2', MAX(index) FROM galleries' but I'm still getting an error... any ideas?
<20> found it i think http://www.w3schools.com/sql/sql_join.asp
<20> thnx
<18> someone?
<18> I saw some examples that take all the values from another row with the SELECT method.. I want only to get one value(for the 'index') and to insert the other ones myself
<18> plz?
Return to
#sql
or
Go to some related
logs:
#freebsd
#beginner
#hardware
#netbsd
7mamat
#windows
#computers
yoshimura gp evo
#gentoo
#politics
|
|