From a.r.mccoy at larc.nasa.gov Mon Apr 25 07:55:39 2005 From: a.r.mccoy at larc.nasa.gov (Alan McCoy) Date: Mon, 25 Apr 2005 08:55:39 -0400 Subject: [thelist] flash webcamvoice chat In-Reply-To: <000601c54753$65b8e180$0501a8c0@cartesiapvek83> References: <7470E917C11D7241A35D9590355614710582F05A@cdfnexc7.NA.Sappi.com><426901E1.30206@mccmh.net> <42691B45.5010009@kasimir-k.fi> <000601c54753$65b8e180$0501a8c0@cartesiapvek83> Message-ID: <426CE8CB.3060107@larc.nasa.gov> Jeroen Wijers wrote: > Hi all, > > Does anyone know or used this? > http://avflashcom.com/avPro/ Jeroen, Everything in that app is easily (and I mean VERY easily) built using the FCS components in Flash MX 2004 Pro. All you need is a web host with a Flash Communication Server installed or download the free developer version for Windows or Linux and have up to 4 or 5 (can't remember which) available connections. This is how easy it is: Hope this helps! Alan From info at internetvraagbaak.nl Mon Apr 25 08:43:32 2005 From: info at internetvraagbaak.nl (Jeroen Wijers) Date: Mon, 25 Apr 2005 15:43:32 +0200 Subject: [thelist] flash webcamvoice chat References: <7470E917C11D7241A35D9590355614710582F05A@cdfnexc7.NA.Sappi.com><426901E1.30206@mccmh.net><42691B45.5010009@kasimir-k.fi><000601c54753$65b8e180$0501a8c0@cartesiapvek83> <426CE8CB.3060107@larc.nasa.gov> Message-ID: <000c01c5499c$c58b6560$0501a8c0@cartesiapvek83> Hi Alan, Well thanks!!! SO now i see why they can sell it that cheap ( 39 Dollars) Jeroen ----- Original Message ----- From: "Alan McCoy" To: Sent: Monday, April 25, 2005 2:55 PM Subject: Re: [thelist] flash webcamvoice chat > Jeroen Wijers wrote: >> Hi all, >> >> Does anyone know or used this? >> http://avflashcom.com/avPro/ > > Jeroen, > > Everything in that app is easily (and I mean VERY easily) built using > the FCS components in Flash MX 2004 Pro. All you need is a web host with > a Flash Communication Server installed or download the free developer > version for Windows or Linux and have up to 4 or 5 (can't remember > which) available connections. > > This is how easy it is: > > > Hope this helps! > > Alan > -- > > * * Please support the community that supports you. * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip Harvester > and archives of thelist go to: http://lists.evolt.org > Workers of the Web, evolt ! > From Matt_Mozer at intuit.com Mon Apr 25 09:46:46 2005 From: Matt_Mozer at intuit.com (Mozer, Matt) Date: Mon, 25 Apr 2005 07:46:46 -0700 Subject: [thelist] XSLT 2.0 replace < > special characters Message-ID: I am trying to do a search and replace on an element with a regex. The problem I am having is on the replace. I am looking for any http(s) strings and needing to create an href out of it. This code below works for replace any http(s) with say a text result such as "fred" or "bob" - for example. You can see what I am trying to do with it though with the a href. The element in this case "whatever" could have multiple http references and are contained in a text element of arbitrary content and length. So, with that being said, the below example is not what I'm looking for as someone has already pointed out. I have tried something similar to no avail. I need to be able to escape the "<" & ">" characters or change my approach entirely... I think this would prove to be a valuable tool if it were to work. -Matt From alex at deltatraffic.co.uk Mon Apr 25 10:18:36 2005 From: alex at deltatraffic.co.uk (Alexander Beston) Date: Mon, 25 Apr 2005 16:18:36 +0100 Subject: [thelist] automation on members only sites Message-ID: <426D0A4C.4070202@deltatraffic.co.uk> Hi all Im running a members only site with a mail facility to contact other members. over the weekend some kind of automated browser has searched for members, send them a mail and repeated indefinately. the pattern of accesses in the logs are too regular to be anything other than machine driven. most worryingly of all, each member has a db table showing who & when a members details were viewed, but here nothing is recorded for any member shown as viewed in the logs. are these programs readily available? how do you block them? has anyone any experience of this sort of thing? thanks, Alex From andrew at milords.com Mon Apr 25 10:45:31 2005 From: andrew at milords.com (A Maynes) Date: Mon, 25 Apr 2005 16:45:31 +0100 Subject: [thelist] automation on members only sites In-Reply-To: <426D0A4C.4070202@deltatraffic.co.uk> Message-ID: <000601c549ad$d0116d20$4c64a8c0@WEBALIZER> Sounds like your DB has been comprised MySQL by any chance? Andrew > -----Original Message----- > From: Alexander Beston [mailto:alex at deltatraffic.co.uk] > Sent: 25 April 2005 16:19 > To: Evolt mailing list > Subject: [thelist] automation on members only sites > > > Hi all > > Im running a members only site with a mail facility to contact other > members. > > over the weekend some kind of automated browser has searched for > members, send them a mail and repeated indefinately. > > the pattern of accesses in the logs are too regular to be > anything other > than machine driven. > > most worryingly of all, each member has a db table showing > who & when a > members details were viewed, but here nothing is recorded for > any member > shown as viewed in the logs. > > are these programs readily available? how do you block them? > has anyone > any experience of this sort of thing? > > thanks, > Alex > > > > -- > > * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! From alex at deltatraffic.co.uk Mon Apr 25 11:22:36 2005 From: alex at deltatraffic.co.uk (Alexander Beston) Date: Mon, 25 Apr 2005 17:22:36 +0100 Subject: [thelist] automation on members only sites In-Reply-To: <000601c549ad$d0116d20$4c64a8c0@WEBALIZER> References: <000601c549ad$d0116d20$4c64a8c0@WEBALIZER> Message-ID: <426D194C.7080709@deltatraffic.co.uk> A Maynes wrote: >Sounds like your DB has been comprised MySQL by any chance? > >Andrew > > how would I go about check if it had or not? I was thinking of a quick fix to spam on members sites to limit the daily send out to say 10 or 20. Alex From sales at lycosa.co.uk Mon Apr 25 12:26:26 2005 From: sales at lycosa.co.uk (Sales) Date: Mon, 25 Apr 2005 18:26:26 +0100 Subject: [thelist] site evaluation In-Reply-To: Message-ID: <000b01c549bb$e8e76d00$0201a8c0@p2> Thanks for all your comments regarding http://www.bluelizardstudio.co.uk It is very helpful. Phil www.lycosa.co.uk From Brian at hondaswap.com Mon Apr 25 12:40:01 2005 From: Brian at hondaswap.com (Brian Cummiskey) Date: Mon, 25 Apr 2005 13:40:01 -0400 Subject: [thelist] dynamic table sql question Message-ID: <426D2B71.3020907@hondaswap.com> i'm trying to write a simple query to check each and every table for a certain group of phone numbers from another table which lists all the jobs and its properties. this is what i want to do... select * from (select distinct job_name from jobs) where phonenumber IN ( <> ) basically, i want to cycle through each job name from the Jobs table, and within the same database, there is a table with that Job name. I.e. Jobs holds: Job1, Job2 and I have the following tables: Jobs Job1 Job2 in my main listing under the DB. I know this syntax fails.. but is there a way to do such a thing? I really don't want to go through and do this manually for 300 different job tables to see if those phone numbers are in it. From joshua at waetech.com Mon Apr 25 12:54:16 2005 From: joshua at waetech.com (Joshua Olson) Date: Mon, 25 Apr 2005 13:54:16 -0400 Subject: [thelist] dynamic table sql question In-Reply-To: <426D2B71.3020907@hondaswap.com> Message-ID: > -----Original Message----- > From: Brian Cummiskey > Sent: Monday, April 25, 2005 1:40 PM > I really don't want to go through and do this manually for > 300 different > job tables to see if those phone numbers are in it. It may be possible to do this in a stored procedure depending on your database. Which database are you using? <><><><><><><><><><> Joshua L. Olson WAE Tech Inc. http://www.waetech.com/ Phone: 706.210.0168 Monitor bandwidth usage on IIS6 in real-time: http://www.waetech.com/services/iisbm/ From teke at pullman.com Mon Apr 25 12:54:44 2005 From: teke at pullman.com (teke at pullman.com) Date: Mon, 25 Apr 2005 17:54:44 GMT Subject: [thelist] dynamic table sql question Message-ID: <200504251755.j3PHtD6N061429@mail-gw.fsr.net> Union should do the trick. > i'm trying to write a simple query to check each and every table for a > certain group of phone numbers from another table which lists all the > jobs and its properties. > > this is what i want to do... > > > select * from (select distinct job_name from jobs) > where phonenumber IN ( <> ) > > basically, i want to cycle through each job name from the Jobs table, > and within the same database, there is a table with that Job name. > > I.e. Jobs holds: Job1, Job2 > and I have the following tables: > Jobs > Job1 > Job2 > in my main listing under the DB. > > > I know this syntax fails.. but is there a way to do such a thing? > > > > I really don't want to go through and do this manually for 300 different > job tables to see if those phone numbers are in it. > > -- > > * * Please support the community that supports you. * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip Harvester > and archives of thelist go to: http://lists.evolt.org > Workers of the Web, evolt ! > --------------------------------------------- This message was sent by First Step Internet. http://www.fsr.com/ From Ed at ComSimplicity.com Mon Apr 25 13:00:00 2005 From: Ed at ComSimplicity.com (Ed McCarroll) Date: Mon, 25 Apr 2005 11:00:00 -0700 Subject: [thelist] dynamic table sql question In-Reply-To: <426D2B71.3020907@hondaswap.com> References: <426D2B71.3020907@hondaswap.com> Message-ID: <1114452000.426d30208b7ae@webmail.comsimplicity.com> > select * from (select distinct job_name from jobs) > where phonenumber IN ( <> ) Off the top of my head (no way to test here): SELECT * FROM WhateverTable W INNER JOIN jobs J ON J.job_name = W.job_name WHERE phonenumber IN ( <> ) -------------------------------------------------------------------- Ed McCarroll (310) 838-4330 Ed at ComSimplicity.com http://www.ComSimplicity.com From jay.blanchard at niicommunications.com Mon Apr 25 12:57:17 2005 From: jay.blanchard at niicommunications.com (Jay Blanchard) Date: Mon, 25 Apr 2005 12:57:17 -0500 Subject: [thelist] dynamic table sql question Message-ID: [snip] i'm trying to write a simple query to check each and every table for a certain group of phone numbers from another table which lists all the jobs and its properties. this is what i want to do... select * from (select distinct job_name from jobs) where phonenumber IN ( <> ) basically, i want to cycle through each job name from the Jobs table, and within the same database, there is a table with that Job name. I.e. Jobs holds: Job1, Job2 and I have the following tables: Jobs Job1 Job2 in my main listing under the DB. [/snip] I am not sure that you have provided enough information here or I just don't understand, but lets see if we can make order of it. You need to check a large number of tables for a list of phone numbers from one table? What is your database software and are you using PHP or ASP or PERL or anything like that? From warren at digital-crossroads.com Mon Apr 25 13:53:35 2005 From: warren at digital-crossroads.com (Warren Murray) Date: Mon, 25 Apr 2005 14:53:35 -0400 Subject: [thelist] MySQL to PostgreSQL Conversion Message-ID: <426D3CAF.6090607@digital-crossroads.com> What's wrong with this SQL Statement in the my conversion from MySQL to PostgreSQL? DROP TABLE "tblattachment"; CREATE TABLE "tblattachment" ( "A_ID" varchar(38) NOT NULL default '', "A_Parent" varchar(38) NOT NULL default '', "A_Classification" INT4 default '0', "A_Releasability" varchar(65) default NULL, "A_Type" varchar(65) default NULL, "A_Name" varchar(65) NOT NULL default '', "A_Description" varchar(255) default NULL, "A_Content" longblob, "A_Owner" varchar(38) NOT NULL default '', "A_DateUpdated" datetime default NULL, PRIMARY KEY ("A_ID"), CREATE INDEX "A_Parent" ON TABLE ("A_Parent") ) ENGINE=InnoDB DEFAULT CHARSET=utf8; It fails with this error: "ERROR: syntax error at or near "CREATE" at character 509"; Thanks! Warren From joshua at waetech.com Mon Apr 25 14:03:58 2005 From: joshua at waetech.com (Joshua Olson) Date: Mon, 25 Apr 2005 15:03:58 -0400 Subject: [thelist] Nova Alternative Message-ID: Just got a cold-call from "Federated" [0]. Any thoughts on going through them for cc processing? Are they on-par with Nova? [0] http://www.federatedpayments.com/ <><><><><><><><><><> Joshua L. Olson WAE Tech Inc. http://www.waetech.com/ Phone: 706.210.0168 Monitor bandwidth usage on IIS6 in real-time: http://www.waetech.com/services/iisbm/ From Brian at hondaswap.com Mon Apr 25 14:26:00 2005 From: Brian at hondaswap.com (Brian Cummiskey) Date: Mon, 25 Apr 2005 15:26:00 -0400 Subject: [thelist] dynamic table sql question In-Reply-To: <1114452000.426d30208b7ae@webmail.comsimplicity.com> References: <426D2B71.3020907@hondaswap.com> <1114452000.426d30208b7ae@webmail.comsimplicity.com> Message-ID: <426D4448.3050904@hondaswap.com> Ed McCarroll wrote: > SELECT * FROM WhateverTable W > INNER JOIN jobs J ON J.job_name = W.job_name > WHERE phonenumber IN ( <> ) That's not going to work... I would need to be able to cycle through WhateverTable for the entire list of tables in the Jobs table. I would have to go through all 300+ job tables and change WhaterTable to reflect that name. Thanks for the idea though... Joshua Olsen Wrote: > It may be possible to do this in a stored procedure depending on your > database. Which database are you using? Sorry, i wasn't clear. I am using M$SQL 2000 (version 7 i think?) i can use asp/stored proceudre/triggers if need be, but i don't need to export the results to anything. Basically, i just need to get a list of the unique ID's from each table in the database where those numbers are located. I'm just trying to run the query in Query Analyzier. A little info about what i'm doing- I work for a B2B call center, and we have had some requests to remove from our call list. I need to find all instances of these numbers if they exist for other jobs, and set the status to 'u' for uncallable in every table. There's a good chance that our lists will overlap for big jobs. Teke at union.com Wrote: > Union should do the trick. yes, it would- but that would still require me to manually union all 300+ tables. Not something i'm looking forward to doing, and human error can exist-- theres a good chance i could miss one by accident. Jay Blanchard Wrote: > I am not sure that you have provided enough information here or I just > don't understand, but lets see if we can make order of it. You need to > check a large number of tables for a list of phone numbers from one > table? What is your database software and are you using PHP or ASP or > PERL or anything like that? No, i need to check if the phone numbers exist in MULTIPLE tables. Thus, i want to generate a sub-query that will populate the table names. Luckily, i already have a table that holds this information-- that's the Jobs table, which holds the JobID, which is the name of the 300+ tables i need to look in. As stated above, this is MS SQL. don't really need a web front end. I plan to run an update query once i have all the rowid's for the records to set the callable status to 'u' for uncallable. Thanks for the help so far guys. Let's see if this added info can get us anywhere :) From chris at logorocks.com Mon Apr 25 14:28:30 2005 From: chris at logorocks.com (Chris Kavanagh) Date: Mon, 25 Apr 2005 20:28:30 +0100 Subject: [thelist] automation on members only sites In-Reply-To: <000601c549ad$d0116d20$4c64a8c0@WEBALIZER> References: <000601c549ad$d0116d20$4c64a8c0@WEBALIZER> Message-ID: <9bd1a4c561100200ef35192e2cd1867c@logorocks.com> A Maynes wrote: > Sounds like your DB has been comprised MySQL by any chance? Hey, I use MySQL, in kind of a rookie way. Something I should know? Kind regards, CK. From joshua at waetech.com Mon Apr 25 14:47:17 2005 From: joshua at waetech.com (Joshua Olson) Date: Mon, 25 Apr 2005 15:47:17 -0400 Subject: [thelist] dynamic table sql question In-Reply-To: <426D4448.3050904@hondaswap.com> Message-ID: > -----Original Message----- > From: Brian Cummiskey > Sent: Monday, April 25, 2005 3:26 PM > > Joshua Olsen Wrote: > > It may be possible to do this in a stored procedure > depending on your > > database. Which database are you using? > > Sorry, i wasn't clear. > I am using M$SQL 2000 (version 7 i think?) Er, MSSQL 2000 is just that... not version 7. :-) > Teke at union.com Wrote: > > Union should do the trick. > > yes, it would- but that would still require me to manually union all > 300+ tables. Not something i'm looking forward to doing, and human > error can exist-- theres a good chance i could miss one by accident. Here's one thought--create an SP that makes the UNION for you (compiled as a string) based on the available information. Then, execute that string using the EXECUTE keyword. <><><><><><><><><><> Joshua L. Olson WAE Tech Inc. http://www.waetech.com/ Phone: 706.210.0168 Monitor bandwidth usage on IIS6 in real-time: http://www.waetech.com/services/iisbm/ From Ed at ComSimplicity.com Mon Apr 25 14:57:20 2005 From: Ed at ComSimplicity.com (Ed McCarroll) Date: Mon, 25 Apr 2005 12:57:20 -0700 Subject: [thelist] dynamic table sql question In-Reply-To: <426D4448.3050904@hondaswap.com> References: <426D2B71.3020907@hondaswap.com> <1114452000.426d30208b7ae@webmail.comsimplicity.com> <426D4448.3050904@hondaswap.com> Message-ID: <1114459040.426d4ba04e723@webmail.comsimplicity.com> Perhaps you should show us more detail about your schema. Why do you have 300 tables that require the same processing? Maybe you need to set up a procedure that uses a cursor to cycle through your tables. SQL Server has system-defined views that should allow you to do this. -------------------------------------------------------------------- Ed McCarroll (310) 838-4330 Ed at ComSimplicity.com http://www.ComSimplicity.com From peter at easylistbox.com Mon Apr 25 15:01:59 2005 From: peter at easylistbox.com (Peter Brunone (EasyListBox.com)) Date: Mon, 25 Apr 2005 13:01:59 -0700 Subject: [thelist] dynamic table sql question Message-ID: <1e7917bdb4bc4263a2ab96e5c2d88074@easylistbox.com> ???Well, my first reaction would be "why the heck did they design the database this way", but since I doubt you have any control over that, let's press on.? Can we assume that the structure (or at least the names of the fields) are the same in all these subordinate tables?? If so, I recommend?the following: 1)? First do a select query from systables.? Get all tables with names like 'Job%'. 2)? Cycle through this recordset and create a string that contains the update query for that table. 3)? Use sp_executesql (in a stored proc; otherwise just send the string) to execute the query. ???SQL Books Online can tell you how to do this in TSQL; otherwise, you can just slap together a script or assembly in whatever language/environment you choose. > I plan to run an update query once i have all the rowid's > for the records to set the callable status to 'u' for uncallable. ???Wait... how are you going to identify which row ID is in which table?? Do you want to have to find them all over again?? If you need to report the records changed, you'll need to insert the values into a temp table (if you go the stored proc route) or bring them back in an array or hashtable for display on the client (if you go that way). ???Did that 5000-foot analysis?make any sense? From: Brian Cummiskey Brian at hondaswap.com Ed McCarroll wrote: > SELECT * FROM WhateverTable W > INNER JOIN jobs J ON J.job_name = W.job_name > WHERE phonenumber IN ( <> ) That's not going to work... I would need to be able to cycle through WhateverTable for the entire list of tables in the Jobs table. I would have to go through all 300+ job tables and change WhaterTable to reflect that name. Thanks for the idea though... Joshua Olsen Wrote: > It may be possible to do this in a stored procedure depending on your > database. Which database are you using? Sorry, i wasn't clear. I am using M$SQL 2000 (version 7 i think?) i can use asp/stored proceudre/triggers if need be, but i don't need to export the results to anything. Basically, i just need to get a list of the unique ID's from each table in the database where those numbers are located. I'm just trying to run the query in Query Analyzier. A little info about what i'm doing- I work for a B2B call center, and we have had some requests to remove from our call list. I need to find all instances of these numbers if they exist for other jobs, and set the status to 'u' for uncallable in every table. There's a good chance that our lists will overlap for big jobs. Teke at union.com Wrote: > Union should do the trick. yes, it would- but that would still require me to manually union all 300+ tables. Not something i'm looking forward to doing, and human error can exist-- theres a good chance i could miss one by accident. Jay Blanchard Wrote: > I am not sure that you have provided enough information here or I just > don't understand, but lets see if we can make order of it. You need to > check a large number of tables for a list of phone numbers from one > table? What is your database software and are you using PHP or ASP or > PERL or anything like that? No, i need to check if the phone numbers exist in MULTIPLE tables. Thus, i want to generate a sub-query that will populate the table names. Luckily, i already have a table that holds this information-- that's the Jobs table, which holds the JobID, which is the name of the 300+ tables i need to look in. As stated above, this is MS SQL. don't really need a web front end. I plan to run an update query once i have all the rowid's for the records to set the callable status to 'u' for uncallable. Thanks for the help so far guys. Let's see if this added info can get us anywhere :) From pixelmech at yahoo.com Mon Apr 25 15:56:05 2005 From: pixelmech at yahoo.com (Tom Dell'Aringa) Date: Mon, 25 Apr 2005 13:56:05 -0700 (PDT) Subject: [thelist] DOM - adding a function to a dynamically added element... Message-ID: <20050425205605.59413.qmail@web51402.mail.yahoo.com> Hi there, I'm rusty and have forgotten the best way to do this. I'm adding a link inside a DIV dynamically on my page using the DOM. This link needs to have a function tied to the onclick event handler. If I remember correctly, you cannot do this using .setAttribute - because IE doesn't like it (based on my tests, that is what is happening) I had thought then you added it using the property of the object: myLink.onclick = functionName; ( with or without the brackets?) But this doesn't seem to work. My problem is compounded by the fact that I want the link to return false: The link should be this: Page Help Do I have to write this as an anonymous(?) function like: myLink.onclick = function { statements here } I'm rusty on this stuff it has been awhile, I can't remember the correct way. I also don't see a way to add the return false, or maybe 'return toggleHelp()' then return false in the function...still how would I add the return? I need to call this function from this link... Thanks Tom http://www.pixelmech.com/ Melissa: Ace, Where are you? Ace Ventura: I'm in Psychoville and Finkle's the Mayor. From Brian at hondaswap.com Mon Apr 25 15:57:04 2005 From: Brian at hondaswap.com (Brian Cummiskey) Date: Mon, 25 Apr 2005 16:57:04 -0400 Subject: [thelist] dynamic table sql question In-Reply-To: <1e7917bdb4bc4263a2ab96e5c2d88074@easylistbox.com> References: <1e7917bdb4bc4263a2ab96e5c2d88074@easylistbox.com> Message-ID: <426D59A0.3060203@hondaswap.com> Peter Brunone (EasyListBox.com) wrote: > Well, my first reaction would be "why the heck did they design the database this way", but since I doubt you have any control over that, let's press on. It actually makes perfect sense. Each Job is from a different client, upon which we are calling on THEIR lists for them. Perhaps I need some sample data to get this together a little better. I don't think anyone is really grasping what i'm dealing with. So, We have for example 2 clients. companyA and companyB each with 2 current jobs. each table has a unique ID to THAT table, as well as a jobid field, which is the same as the table name (for all purposes here.. its a little different, but thats not an issue i can't handel) There is also a Master table, called Jobs which has the Jobid (which is called companyA_1) and holds other useless-to-this-post stuff like description, running dates, etc.. basically, i need to select all job ids from jobs. this will give me companyA_1 companyA_2 companyB_1 companyA_2 and from those tables, i need to generate the: select rowID, jobname from <> where phonenumber in ( <> ) this will hopefully give me row jobname 12345 companyA_1 22345 companyA_2 32345 companyb_1 42345 companyB_2 if there were 4 rows among those tables with the phone numbers i plug in. Is this making more sense now? which is why i want to dynmically geenerate my table name that i select from. I thought about doing it in a scripting language... something like select distinct Jobid from jobs while NOT rst.eof select rowID, jobname from & Jobid & .... wend or something like that. but, i don't need an interface. i just need to run this in query analyizer. > Can we assume that the structure (or at least the names of the fields) are the same in all these subordinate tables? No, not all the same... but the fields i need/care about ARE. > If so, I recommend the following: > > 1) First do a select query from systables. Get all tables with names like 'Job%'. Well, that's not going to work. :P I was using job as an example, but they are all different names. there's no real structure to them other than they are less than 8 chars. > 2) Cycle through this recordset and create a string that contains the update query for that table. > > 3) Use sp_executesql (in a stored proc; otherwise just send the string) to execute the query. > > SQL Books Online can tell you how to do this in TSQL; otherwise, you can just slap together a script or assembly in whatever language/environment you choose. yeah, so i don't think this is going to work... >>I plan to run an update query once i have all the rowid's >>for the records to set the callable status to 'u' for uncallable. > > > Wait... how are you going to identify which row ID is in which table? the unique id is "smart" it is setup like COUNTJOBID so each id i pull can be associated with its proper table. I'm not expecting many results... 10 tops... so if i have to update manually, it won't be a big deal. It's just a matter of finding them without spending hours trying hunt them down. > Did that 5000-foot analysis make any sense? heh, yes, i followed you- but i don't think its the solution thats going to make it work.... thanks though. From pouncy_1 at hotmail.com Mon Apr 25 17:23:03 2005 From: pouncy_1 at hotmail.com (pouncyisdead) Date: Mon, 25 Apr 2005 15:23:03 -0700 Subject: [thelist] opinions on CMS solutions Message-ID: I know that this is a commonly asked question, but, do any of you have a recommendation for a low-cost, xhtml-valid, content management system? My small company is looking for a CMS that includes support for versioning, and syndication. About us: we are a sports information group with 4 medium sites running on a single windows 2003 server. We've looked into Vignette, Cm3, Documentum and Acuity, but were unhappy with the total costs. Sadly, must of the free offerings (DotNetNuke, Rainbow) didn't seem robust enough for the constant updates and reports that we do each day. Mike Pouncy [Technical Supervisor] [WEB]-[http://fpbe.com] [MSN]-[pouncy_1 at hotmail.com] From joshua at waetech.com Mon Apr 25 17:43:39 2005 From: joshua at waetech.com (Joshua Olson) Date: Mon, 25 Apr 2005 18:43:39 -0400 Subject: [thelist] dynamic table sql question In-Reply-To: <426D59A0.3060203@hondaswap.com> Message-ID: > -----Original Message----- > From: Brian Cummiskey > Sent: Monday, April 25, 2005 4:57 PM > Perhaps I need some sample data to get this together a little > better. I don't think anyone is really grasping what i'm > dealing with. If that ain't a conversation ender, I'm not sure what is. :-) Regardless, you'll still want a UNION, and you may want to look at creating the SQL for the UNION dynamically within a stored procedure, just as myself and Peter (except he accidentally used the word UPDATE instead of UNION) have suggested. Assuming you are describing your problem correctly, this will work, and may be the single easiest way to accomplish this task. <><><><><><><><><><> Joshua L. Olson WAE Tech Inc. http://www.waetech.com/ Phone: 706.210.0168 Monitor bandwidth usage on IIS6 in real-time: http://www.waetech.com/services/iisbm/ From dudrenov at gmail.com Mon Apr 25 17:50:20 2005 From: dudrenov at gmail.com (Pavel Dudrenov) Date: Mon, 25 Apr 2005 15:50:20 -0700 Subject: [thelist] DOM - adding a function to a dynamically added element... In-Reply-To: <20050425205605.59413.qmail@web51402.mail.yahoo.com> References: <20050425205605.59413.qmail@web51402.mail.yahoo.com> Message-ID: <10c3e4e005042515504cba6aaf@mail.gmail.com> Dude there are a few things you can do. But the main to are: First don't use setAttribute cuz' that wont work on IE. myEl.onclick = functionName "NOTE you have to put the function name as a variable without the (); or else the function will get executed right there on the spot when the browser parses the code - so no () " but if you do need to pass something to your function you would have to use anon function like you suggested myEl.onclick = function () {functionName(this);} or you can use addEventListener/attachEvent Hope this helps, Pavel Dudrenov On 4/25/05, Tom Dell'Aringa wrote: > Hi there, I'm rusty and have forgotten the best way to do this. > > I'm adding a link inside a DIV dynamically on my page using the DOM. This link needs to have a > function tied to the onclick event handler. If I remember correctly, you cannot do this using > .setAttribute - because IE doesn't like it (based on my tests, that is what is happening) > > I had thought then you added it using the property of the object: > > myLink.onclick = functionName; ( with or without the brackets?) > > But this doesn't seem to work. My problem is compounded by the fact that I want the link to return > false: The link should be this: > > Page Help > > Do I have to write this as an anonymous(?) function like: > > myLink.onclick = function { statements here } > > I'm rusty on this stuff it has been awhile, I can't remember the correct way. I also don't see a > way to add the return false, or maybe 'return toggleHelp()' then return false in the > function...still how would I add the return? I need to call this function from this link... > > Thanks > > Tom > > http://www.pixelmech.com/ > > Melissa: Ace, Where are you? > Ace Ventura: I'm in Psychoville and Finkle's the Mayor. > > -- > > * * Please support the community that supports you. * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip Harvester > and archives of thelist go to: http://lists.evolt.org > Workers of the Web, evolt ! > From discuss at alphanumeric.cz Mon Apr 25 18:01:59 2005 From: discuss at alphanumeric.cz (Jan Brasna) Date: Tue, 26 Apr 2005 01:01:59 +0200 Subject: [thelist] opinions on CMS solutions In-Reply-To: References: Message-ID: <426D76E7.9030004@alphanumeric.cz> > I know that this is a commonly asked question, but, do any of you have a > recommendation for a low-cost, xhtml-valid, content management system? My > small company is looking for a CMS that includes support for versioning, and > syndication. Switch to PHP. Solutions like Drupal.org are robust enough and still extensible to provide this functionality (even custom written). -- Jan Brasna aka JohnyB :: www.alphanumeric.cz | www.janbrasna.com From judah at wiredotter.com Mon Apr 25 17:58:29 2005 From: judah at wiredotter.com (Judah McAuley) Date: Mon, 25 Apr 2005 15:58:29 -0700 Subject: [thelist] MySQL to PostgreSQL Conversion In-Reply-To: <426D3CAF.6090607@digital-crossroads.com> References: <426D3CAF.6090607@digital-crossroads.com> Message-ID: <426D7615.1060000@wiredotter.com> My first guess would be the bit that says "ENGINE=InnoDB". InnoDB is an sql engine specific to MySql. As far as I know Postgres doesn't have InnoDB as an engine option. So try removing that bit and see what Postgres has to say. Judah Warren Murray wrote: > What's wrong with this SQL Statement in the my conversion from MySQL to > PostgreSQL? > > DROP TABLE "tblattachment"; > CREATE TABLE "tblattachment" ( > "A_ID" varchar(38) NOT NULL default '', > "A_Parent" varchar(38) NOT NULL default '', > "A_Classification" INT4 default '0', > "A_Releasability" varchar(65) default NULL, > "A_Type" varchar(65) default NULL, > "A_Name" varchar(65) NOT NULL default '', > "A_Description" varchar(255) default NULL, > "A_Content" longblob, > "A_Owner" varchar(38) NOT NULL default '', > "A_DateUpdated" datetime default NULL, > PRIMARY KEY ("A_ID"), > CREATE INDEX "A_Parent" ON TABLE ("A_Parent") > ) ENGINE=InnoDB DEFAULT CHARSET=utf8; > > It fails with this error: "ERROR: syntax error at or near "CREATE" at > character 509"; > > Thanks! > > Warren From meganwh at wi.rr.com Mon Apr 25 20:22:50 2005 From: meganwh at wi.rr.com (Megan Holbrook) Date: Mon, 25 Apr 2005 18:22:50 -0700 Subject: [thelist] opinions on CMS solutions In-Reply-To: References: Message-ID: <426D97EA.1030204@wi.rr.com> I'm not sure what your price point is for low cost, but I really like the one that Estco.net has (Medigent CMS) at around $25k. They also do custom programming for any special modules necessary. We did the RIF.org site with them, and really like their work. Contact John Estafanous if you have any questions, at jesto at estco.net HTH, M. pouncyisdead wrote: > I know that this is a commonly asked question, but, do any of you have a > recommendation for a low-cost, xhtml-valid, content management system? My > small company is looking for a CMS that includes support for versioning, and > syndication. > > About us: we are a sports information group with 4 medium sites running on a > single windows 2003 server. We've looked into Vignette, Cm3, Documentum and > Acuity, but were unhappy with the total costs. Sadly, must of the free > offerings (DotNetNuke, Rainbow) didn't seem robust enough for the constant > updates and reports that we do each day. > > Mike Pouncy [Technical Supervisor] > [WEB]-[http://fpbe.com] [MSN]-[pouncy_1 at hotmail.com] -- Megan Holbrook - megan at kapow.com Partner - Business Development kapow, inc. (www.kapow.com) - website design and development kapow, inc. Milwaukee kapow, inc. Los Angeles 2405 E. Wyoming Place 1301 Montana Ave., Suite A Milwaukee, WI 53202 Santa Monica, CA 90403 T: 414-273-2446 * F: 419-278-9056 T: 310.394.5276 * F: 310.394.5278 From jdillon at boehm-ritter.com Mon Apr 25 18:25:58 2005 From: jdillon at boehm-ritter.com (Jonathan Dillon) Date: Mon, 25 Apr 2005 16:25:58 -0700 Subject: [thelist] opinions on CMS solutions In-Reply-To: Message-ID: <20050425223734.1872C5187AA@mx1.nexiderm.com> Look at: http://www.ez.no/ http://www.plainblack.com/ http://www.drupal.com/ http://www.plone.org/ http://www.mambo.org/ http://www.magnolia.info/ http://www.opencms.org/ http://www.openacs.org/ http://www.typo3.org/ And bricolage... Then read this: http://www.cmswatch.com/Features/OpinionWatch/FeaturedOpinion/?feature_id=89 And then review this page: http://www.cmswatch.com/ContentManagement/Products/ Bottom line... Lot out there, not much is very good. The above is listed in order of my personal (biased) reccomendation. However, I run an eZ Publish company, so please take it's top rating for a grain of salt: like I said, I'm biased. ;-) You might look for some 15-40k solutions in the above CMS Watch link. Ektron, Roxen, Refresh, Sitecore, and a host of others not mentioned fill this space. I'm also somewhat fond of a product called hotbanana (http://www.hotbanana.com/), which has excellent UI and helpful staff, and rests squarely in the bottom of the price range mentioned. So far, everything you looked at is going to be 60k+, or much more... I would stop looking at the top end of the market for solutions, as they're generally (IMHO) overpriced. Good hunting, Jonathan Dillon-Hayes --- Email: jonathan at boehm-ritter.com http://www.Boehm-Ritter.com/ -----Original Message----- From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of pouncyisdead Sent: Monday, April 25, 2005 3:23 PM To: 'Evolt List' Subject: [thelist] opinions on CMS solutions I know that this is a commonly asked question, but, do any of you have a recommendation for a low-cost, xhtml-valid, content management system? My small company is looking for a CMS that includes support for versioning, and syndication. About us: we are a sports information group with 4 medium sites running on a single windows 2003 server. We've looked into Vignette, Cm3, Documentum and Acuity, but were unhappy with the total costs. Sadly, must of the free offerings (DotNetNuke, Rainbow) didn't seem robust enough for the constant updates and reports that we do each day. Mike Pouncy [Technical Supervisor] [WEB]-[http://fpbe.com] [MSN]-[pouncy_1 at hotmail.com] -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! From meganwh at wi.rr.com Mon Apr 25 20:30:57 2005 From: meganwh at wi.rr.com (Megan Holbrook) Date: Mon, 25 Apr 2005 18:30:57 -0700 Subject: [thelist] opinions on CMS solutions In-Reply-To: References: Message-ID: <426D99D1.3070704@wi.rr.com> BTW - if you are looking farther (further?) afield into open source, we did quite a bit of research and chose Zope/Plone for two sites, and are just about to embark on using Mambo for another two. Lot of relative advantages and disadvantages to each open source CMS so it's key to choose the right one for your project (you can start at www.cmswatch.com or www.cmsmatrix.org for comparisons), but hey, it's hard to beat the price... ;) M. pouncyisdead wrote: > I know that this is a commonly asked question, but, do any of you have a > recommendation for a low-cost, xhtml-valid, content management system? My > small company is looking for a CMS that includes support for versioning, and > syndication. > > About us: we are a sports information group with 4 medium sites running on a > single windows 2003 server. We've looked into Vignette, Cm3, Documentum and > Acuity, but were unhappy with the total costs. Sadly, must of the free > offerings (DotNetNuke, Rainbow) didn't seem robust enough for the constant > updates and reports that we do each day. > > Mike Pouncy [Technical Supervisor] > [WEB]-[http://fpbe.com] [MSN]-[pouncy_1 at hotmail.com] -- Megan Holbrook - megan at kapow.com Partner - Business Development kapow, inc. (www.kapow.com) - website design and development kapow, inc. Milwaukee kapow, inc. Los Angeles 2405 E. Wyoming Place 1301 Montana Ave., Suite A Milwaukee, WI 53202 Santa Monica, CA 90403 T: 414-273-2446 * F: 419-278-9056 T: 310.394.5276 * F: 310.394.5278 From philip at turmel.org Mon Apr 25 18:33:11 2005 From: philip at turmel.org (Phil Turmel) Date: Mon, 25 Apr 2005 19:33:11 -0400 Subject: [thelist] DOM - adding a function to a dynamically added element... In-Reply-To: <20050425205605.59413.qmail@web51402.mail.yahoo.com> References: <20050425205605.59413.qmail@web51402.mail.yahoo.com> Message-ID: <426D7E37.1080603@turmel.org> Tom Dell'Aringa wrote: > Hi there, I'm rusty and have forgotten the best way to do this. > > I'm adding a link inside a DIV dynamically on my page using the DOM. This link needs to have a > function tied to the onclick event handler. If I remember correctly, you cannot do this using > .setAttribute - because IE doesn't like it (based on my tests, that is what is happening) > > I had thought then you added it using the property of the object: > > myLink.onclick = functionName; ( with or without the brackets?) > > But this doesn't seem to work. My problem is compounded by the fact that I want the link to return > false: The link should be this: > > Page Help > > Do I have to write this as an anonymous(?) function like: > > myLink.onclick = function { statements here } > > I'm rusty on this stuff it has been awhile, I can't remember the correct way. I also don't see a > way to add the return false, or maybe 'return toggleHelp()' then return false in the > function...still how would I add the return? I need to call this function from this link... > > Thanks > > Tom Pretty close... the function's return value takes care of your problem. Try one of these: myLink.onclick = function (e) { statement; statement; return false; }; OR, function functionName (e) { statement; statement; return false; } myLink.onclick = functionName; Note the (e) in the function definitions... that gives you access to the event properties during the event. For a thorough treatment: http://www.quirksmode.org/js/introevents.html HTH, Phil From rob at stewart-douglas.com Mon Apr 25 19:52:00 2005 From: rob at stewart-douglas.com (Robert Stewart) Date: Mon, 25 Apr 2005 17:52:00 -0700 Subject: [thelist] Quick XHTML job Message-ID: <994170B8F725D3458C2D12B8E849F23F0202DD@psycho.sfbats.com> I have a small XHTML job that requires a quick turn around for anyone who might be interested. Please contact off list of course. Robert Stewart From warren at digital-crossroads.com Mon Apr 25 21:12:30 2005 From: warren at digital-crossroads.com (Warren) Date: Mon, 25 Apr 2005 22:12:30 -0400 Subject: [thelist] MySQL to PostgreSQL Conversion In-Reply-To: <426D7615.1060000@wiredotter.com> References: <426D3CAF.6090607@digital-crossroads.com> <426D7615.1060000@wiredotter.com> Message-ID: <426DA38E.8000704@digital-crossroads.com> I did some moving around and removed InnoDB and finally got the thing to work. I have about 47 tables to convert. Thanks! Judah McAuley wrote: > My first guess would be the bit that says "ENGINE=InnoDB". InnoDB is > an sql engine specific to MySql. As far as I know Postgres doesn't > have InnoDB as an engine option. So try removing that bit and see what > Postgres has to say. > > Judah > > Warren Murray wrote: > >> What's wrong with this SQL Statement in the my conversion from MySQL >> to PostgreSQL? >> >> DROP TABLE "tblattachment"; >> CREATE TABLE "tblattachment" ( >> "A_ID" varchar(38) NOT NULL default '', >> "A_Parent" varchar(38) NOT NULL default '', >> "A_Classification" INT4 default '0', >> "A_Releasability" varchar(65) default NULL, >> "A_Type" varchar(65) default NULL, >> "A_Name" varchar(65) NOT NULL default '', >> "A_Description" varchar(255) default NULL, >> "A_Content" longblob, >> "A_Owner" varchar(38) NOT NULL default '', >> "A_DateUpdated" datetime default NULL, >> PRIMARY KEY ("A_ID"), >> CREATE INDEX "A_Parent" ON TABLE ("A_Parent") >> ) ENGINE=InnoDB DEFAULT CHARSET=utf8; >> >> It fails with this error: "ERROR: syntax error at or near "CREATE" >> at character 509"; >> >> Thanks! >> >> Warren > > From peter at easylistbox.com Mon Apr 25 21:20:34 2005 From: peter at easylistbox.com (Peter Brunone (EasyListBox.com)) Date: Mon, 25 Apr 2005 21:20:34 -0500 Subject: SPAM-HIGH: RE: [thelist] dynamic table sql question Message-ID: <001e01c54a06$8757e1f0$0500a8c0@monkeyhouse> Er... Actually, I *did* mean update. I was proposing an approach whereby he would build an update query (in a loop, on the fly) for each table, rather than making a giant 15,000-character union query that merely selects the values and still requires someone to manually update the tables in question. And just for the record -- although perhaps, as Brian suggested, I just don't get it -- this database design still doesn't seem like the best approach. I'm waiting for Ken Schaefer to either back me up or slam dunk me here, since I'm sure he's just about past his morning emails by now :) Cheers, Peter -----Original Message----- From: thelist-bounces at lists.evolt.org On Behalf Of Joshua Olson > -----Original Message----- > From: Brian Cummiskey > Sent: Monday, April 25, 2005 4:57 PM > Perhaps I need some sample data to get this together a little > better. I don't think anyone is really grasping what i'm > dealing with. If that ain't a conversation ender, I'm not sure what is. :-) Regardless, you'll still want a UNION, and you may want to look at creating the SQL for the UNION dynamically within a stored procedure, just as myself and Peter (except he accidentally used the word UPDATE instead of UNION) have suggested. Assuming you are describing your problem correctly, this will work, and may be the single easiest way to accomplish this task. <><><><><><><><><><> Joshua L. Olson WAE Tech Inc. http://www.waetech.com/ Phone: 706.210.0168 Monitor bandwidth usage on IIS6 in real-time: http://www.waetech.com/services/iisbm/ From jeff at jeffhowden.com Mon Apr 25 21:24:40 2005 From: jeff at jeffhowden.com (Jeff Howden) Date: Mon, 25 Apr 2005 19:24:40 -0700 Subject: [thelist] opinions on CMS solutions In-Reply-To: <426D76E7.9030004@alphanumeric.cz> Message-ID: Jan, ><><><><><><><><><><><><><><><><><><><><><><><><><><><><>< > From: Jan Brasna > > Switch to PHP. [...] ><><><><><><><><><><><><><><><><><><><><><><><><><><><><>< Nonsense. There's absolutely *no* need to switch development languages. Solutions in all sorts of price ranges, qualities, and capabilities are available in any of the major development languages (PHP, ASP, CF, Perl, etc.). ><><><><><><><><><><><><><><><><><><><><><><><><><><><><>< > Solutions like Drupal.org are robust enough and still > extensible to provide this functionality [...] ><><><><><><><><><><><><><><><><><><><><><><><><><><><><>< Mike, Extensibility brings with it performance losses, customization issues, learning curve, stability, scalability, increased troubleshooting cost, and bugs. Further, no one product out there can solve all your needs without some custom development (which the product you choose may or may not be able to ever do anyway). Depending on your budget, it *might* be more cost effective to outsource the development to a company that can build a custom solution for you. If your needs are fairly lightweight, it's likely that the project cost will be less than using a product and/or overall cost of an OSS solution. Remember, just because the software itself doesn't cost you anything doesn't mean it'll have a lower total cost of ownership. Jeff ?????????????????????????????????????????????????????? Jeff Howden - Web Application Specialist R?sum? - http://jeffhowden.com/about/resume/ Code Library - http://evolt.jeffhowden.com/jeff/code/ From jeff at jeffhowden.com Mon Apr 25 21:24:32 2005 From: jeff at jeffhowden.com (Jeff Howden) Date: Mon, 25 Apr 2005 19:24:32 -0700 Subject: [thelist] DOM - adding a function to a dynamically addedelement... In-Reply-To: <10c3e4e005042515504cba6aaf@mail.gmail.com> Message-ID: Pavel, ><><><><><><><><><><><><><><><><><><><><><><><><><><><><>< > From: Pavel Dudrenov > > First don't use setAttribute cuz' that wont work on IE. ><><><><><><><><><><><><><><><><><><><><><><><><><><><><>< This simply isn't true. setAttribute() works just fine in IE6+. ><><><><><><><><><><><><><><><><><><><><><><><><><><><><>< > [...] or you can use addEventListener/attachEvent ><><><><><><><><><><><><><><><><><><><><><><><><><><><><>< The use of addEventListener/attachEvent have the same limitations as assigning a function to an even handler in the fashion of "object.eventname = myFunction;". However, more importantly, you immediately run into browser compatibility issues requiring method support branching in your code. I would personally recommend that you avoid these techniques unless you specifically need the ability to add scripting to an event handler an unknown number of times and/or an unknown number of sources. Jeff ?????????????????????????????????????????????????????? Jeff Howden - Web Application Specialist R?sum? - http://jeffhowden.com/about/resume/ Code Library - http://evolt.jeffhowden.com/jeff/code/ From mwarden at gmail.com Mon Apr 25 21:43:45 2005 From: mwarden at gmail.com (Matt Warden) Date: Mon, 25 Apr 2005 22:43:45 -0400 Subject: [thelist] DOM - adding a function to a dynamically addedelement... In-Reply-To: References: <10c3e4e005042515504cba6aaf@mail.gmail.com> Message-ID: On 4/25/05, Jeff Howden wrote: > Pavel, > > ><><><><><><><><><><><><><><><><><><><><><><><><><><><><>< > > From: Pavel Dudrenov > > > > First don't use setAttribute cuz' that wont work on IE. > ><><><><><><><><><><><><><><><><><><><><><><><><><><><><>< > > This simply isn't true. setAttribute() works just fine in IE6+. Are you certain? From my testing, if one tries to set attributes like 'style' using setAttribute rather than the property method, it fails in IE6 (and lower, of course). In fact, here's a page on PPK's site that seems to indicate this as well: http://www.quirksmode.org/dom/w3c_core.html (Ctrl+F setAttribute) There is a test page where you can verify for yourself. Thanks, -- Matt Warden Miami University Oxford, OH, USA http://mattwarden.com This email proudly and graciously contributes to entropy. From Ed at ComSimplicity.com Mon Apr 25 23:07:04 2005 From: Ed at ComSimplicity.com (Ed McCarroll) Date: Mon, 25 Apr 2005 21:07:04 -0700 Subject: SPAM-HIGH: RE: [thelist] dynamic table sql question In-Reply-To: <001e01c54a06$8757e1f0$0500a8c0@monkeyhouse> Message-ID: <001501c54a15$67f2a110$77fa7e18@ed> > And just for the record [...] this database design still doesn't seem > like the best approach. +1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Ed McCarroll http://www.ComSimplicity.com (310) 838-4330 PO Box 654, Culver City, CA 90232 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - From jeff at jeffhowden.com Mon Apr 25 23:35:24 2005 From: jeff at jeffhowden.com (Jeff Howden) Date: Mon, 25 Apr 2005 21:35:24 -0700 Subject: [thelist] DOM - adding a function to a dynamically addedelement... In-Reply-To: Message-ID: Matt, ><><><><><><><><><><><><><><><><><><><><><><><><><><><><>< > From: Matt Warden [mailto:mwarden at gmail.com] > > > This simply isn't true. setAttribute() works just > > fine in IE6+. > > Are you certain? From my testing, if one tries to set > attributes like 'style' using setAttribute rather than > the property method, it fails in IE6 (and lower, of > course). ><><><><><><><><><><><><><><><><><><><><><><><><><><><><>< Ok, true enough. It does not work properly with complex attributes like "style" which is more of an object (internally) and less of an attribute and event handlers which I suppose the pedants (myself included) would argue aren't really attributes, but something else altogether. Everything else does work fine from my experience. Jeff ?????????????????????????????????????????????????????? Jeff Howden - Web Application Specialist R?sum? - http://jeffhowden.com/about/resume/ Code Library - http://evolt.jeffhowden.com/jeff/code/ From Ken at adOpenStatic.com Tue Apr 26 01:57:37 2005 From: Ken at adOpenStatic.com (Ken Schaefer) Date: Tue, 26 Apr 2005 16:57:37 +1000 Subject: [thelist] dynamic table sql question Message-ID: <160489103479AB4892187638EE7D1E6914B9F3@kjserver1.kjhome.local> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ : From: thelist-bounces at lists.evolt.org [mailto:thelist- : bounces at lists.evolt.org] On Behalf Of Brian Cummiskey : Subject: Re: [thelist] dynamic table sql question : : Peter Brunone (EasyListBox.com) wrote: : > Well, my first reaction would be "why the heck did they design the : database this way", but since I doubt you have any control over that, : let's press on. : : It actually makes perfect sense. Each Job is from a different client, : upon which we are calling on THEIR lists for them. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Actually, from where I'm sitting and reading this thread, it doesn't make sense at all. My suspicion is reinforced by the fact that you're having a little difficulty coming up with an SQL query that produces the results you want. Generally, a properly normalised database design gives you queries that are easy to write. Since you are using MS SQL Server 7, can you give us a bunch of CREATE TABLE scripts? (or alternatively describe your design in ER terms, since your current description below doesn't really make much sense). Cheers Ken -- www.adOpenStatic.com/cs/blogs/ken/ : Perhaps I need some sample data to get this together a little better. I : don't think anyone is really grasping what i'm dealing with. : : : So, We have for example 2 clients. : companyA and companyB each with 2 current jobs. : : each table has a unique ID to THAT table, as well as a jobid field, : which is the same as the table name (for all purposes here.. its a : little different, but thats not an issue i can't handel) : : There is also a Master table, called Jobs : which has the Jobid (which is called companyA_1) and holds other : useless-to-this-post stuff like description, running dates, etc.. : : basically, i need to select all job ids from jobs. : : this will give me : : companyA_1 : companyA_2 : companyB_1 : companyA_2 : : : and from those tables, i need to generate the: : : select rowID, jobname from <> : where phonenumber in ( <> ) : : this will hopefully give me : : row jobname : 12345 companyA_1 : 22345 companyA_2 : 32345 companyb_1 : 42345 companyB_2 : : if there were 4 rows among those tables with the phone numbers i plug in. : : : Is this making more sense now? : : which is why i want to dynmically geenerate my table name that i select : from. : : I thought about doing it in a scripting language... something like From Ken at adOpenStatic.com Tue Apr 26 01:59:09 2005 From: Ken at adOpenStatic.com (Ken Schaefer) Date: Tue, 26 Apr 2005 16:59:09 +1000 Subject: SPAM-HIGH: RE: [thelist] dynamic table sql question Message-ID: <160489103479AB4892187638EE7D1E6914B9F4@kjserver1.kjhome.local> I agree entirely with Peter :-) Either I "don't get it", or the database design isn't particularly conducive to getting data back out (which generally means it's not normalised, which generally means bad design). Cheers Ken -- www.adOpenStatic.com/cs/blogs/ken/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ : From: thelist-bounces at lists.evolt.org [mailto:thelist- : bounces at lists.evolt.org] On Behalf Of Peter Brunone (EasyListBox.com) : Subject: RE: SPAM-HIGH: RE: [thelist] dynamic table sql question : : : Er... Actually, I *did* mean update. I was proposing an : approach whereby he would build an update query (in a loop, on the fly) : for each table, rather than making a giant 15,000-character union query : that merely selects the values and still requires someone to manually : update the tables in question. : : And just for the record -- although perhaps, as Brian suggested, : I just don't get it -- this database design still doesn't seem like the : best approach. I'm waiting for Ken Schaefer to either back me up or : slam dunk me here, since I'm sure he's just about past his morning : emails by now :) : : Cheers, : : Peter : : -----Original Message----- : From: thelist-bounces at lists.evolt.org On Behalf Of Joshua Olson : : > -----Original Message----- : > From: Brian Cummiskey : > Sent: Monday, April 25, 2005 4:57 PM : : > Perhaps I need some sample data to get this together a little : > better. I don't think anyone is really grasping what i'm : > dealing with. : : If that ain't a conversation ender, I'm not sure what is. :-) : : Regardless, you'll still want a UNION, and you may want to look at : creating the SQL for the UNION dynamically within a stored procedure, : just as myself and Peter (except he accidentally used the word UPDATE : instead of UNION) have suggested. : : Assuming you are describing your problem correctly, this will work, and : may be the single easiest way to accomplish this task. : : <><><><><><><><><><> : Joshua L. Olson : WAE Tech Inc. : http://www.waetech.com/ : Phone: 706.210.0168 : : Monitor bandwidth usage on IIS6 in real-time: : http://www.waetech.com/services/iisbm/ : : : : -- : : * * Please support the community that supports you. * * : http://evolt.org/help_support_evolt/ : : For unsubscribe and other options, including the Tip Harvester : and archives of thelist go to: http://lists.evolt.org : Workers of the Web, evolt ! From dudrenov at gmail.com Tue Apr 26 02:26:55 2005 From: dudrenov at gmail.com (Pavel Dudrenov) Date: Tue, 26 Apr 2005 00:26:55 -0700 Subject: [thelist] DOM - adding a function to a dynamically addedelement... In-Reply-To: References: Message-ID: <10c3e4e005042600262aa15d42@mail.gmail.com> Jeff, setAttribute() does work for some stuff on IE but you try to add onclick, stlye among other things with setAttibute you will fail in IE. ALso what's wrong with using addEventListener/attachEvent If he need to get to this ( by this I mean the object that's been clicked on) he can easily access it from srcElement/target Pavel On 4/25/05, Jeff Howden wrote: > Matt, > > ><><><><><><><><><><><><><><><><><><><><><><><><><><><><>< > > From: Matt Warden [mailto:mwarden at gmail.com] > > > > > This simply isn't true. setAttribute() works just > > > fine in IE6+. > > > > Are you certain? From my testing, if one tries to set > > attributes like 'style' using setAttribute rather than > > the property method, it fails in IE6 (and lower, of > > course). > ><><><><><><><><><><><><><><><><><><><><><><><><><><><><>< > > Ok, true enough. It does not work properly with complex attributes like > "style" which is more of an object (internally) and less of an attribute and > event handlers which I suppose the pedants (myself included) would argue > aren't really attributes, but something else altogether. > > Everything else does work fine from my experience. > > Jeff > ?????????????????????????????????????????????????????? > Jeff Howden - Web Application Specialist > R?sum? - http://jeffhowden.com/about/resume/ > Code Library - http://evolt.jeffhowden.com/jeff/code/ > > -- > > * * Please support the community that supports you. * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip Harvester > and archives of thelist go to: http://lists.evolt.org > Workers of the Web, evolt ! > From joshua at waetech.com Tue Apr 26 02:47:52 2005 From: joshua at waetech.com (Joshua Olson) Date: Tue, 26 Apr 2005 03:47:52 -0400 Subject: SPAM-HIGH: RE: [thelist] dynamic table sql question In-Reply-To: <001e01c54a06$8757e1f0$0500a8c0@monkeyhouse> Message-ID: > -----Original Message----- > From: Peter Brunone (EasyListBox.com) > Sent: Monday, April 25, 2005 10:21 PM > > > Er... Actually, I *did* mean update. I was proposing an > approach whereby he would build an update query (in a loop, > on the fly) > for each table, rather than making a giant 15,000-character > union query > that merely selects the values and still requires someone to manually > update the tables in question. My apologies! His original post was about selecting records, and knowing that the answer would almost definitely include a UNION given the table structure (horrifying as it may be, it's what he's got!), I made a faulty presumption. In your answer, switching that one word from UPDATE to UNION still made perfect sense, so I figured I was onto something... oh well. :-) <><><><><><><><><><> Joshua L. Olson WAE Tech Inc. http://www.waetech.com/ Phone: 706.210.0168 Monitor bandwidth usage on IIS6 in real-time: http://www.waetech.com/services/iisbm/ From albert.shala at gmail.com Tue Apr 26 03:10:47 2005 From: albert.shala at gmail.com (Albert Shala) Date: Tue, 26 Apr 2005 10:10:47 +0200 Subject: [thelist] PHP Drop down lists Message-ID: <99a55a540504260110ab2d54d@mail.gmail.com> I need help with this urgently: I want to create a drop-down list, kind that you have when you register for say gmail or hotmail, where you select a country from a list. I want to populate this list, manually, since it will only use those values, and none other, and i want the user to be able to select a name from the list, and it's value to be send to the database, so that when i look at the request this user has put in, i should be able to see the correct select he/she had selected.... i hope i'm clear ?!?! From lists at laughing-buddha.net Tue Apr 26 04:02:03 2005 From: lists at laughing-buddha.net (Jon Haworth) Date: Tue, 26 Apr 2005 10:02:03 +0100 Subject: [thelist] PHP Drop down lists In-Reply-To: <99a55a540504260110ab2d54d@mail.gmail.com> Message-ID: <200504260902.j3Q922IJ027594@smtp3.swiftinter.net> Hi Albert, > I want to create a drop-down list, where you select a country > from a list. I want to populate this list, manually ISO country codes: http://userpage.chemie.fu-berlin.de/diverse/doc/ISO_3166.html Should take all of 2 mins to turn that list into a s render on the top of any element in the page, regardless of the elements' z-index. So when you open a DHTML pop-up layer if there is a select beneath it, the select will render on the top of the layer, which is unpleasent visually and in terms of usability. Here is a DOM-compliant way to show/hide selects: function DOMController() {} DOMController.prototype.hideCombos = function() { var arCombo = document.getElementsByTagName("select"); for(var i=0;i cheers, Volkan. From mattias at inreach.com Wed Apr 27 16:31:52 2005 From: mattias at inreach.com (Mattias Thorslund) Date: Wed, 27 Apr 2005 14:31:52 -0700 Subject: [thelist] [OT] Is fixing on a certain platform/programming language good or bad? In-Reply-To: <426FDEE8.1060408@digital-crew.com> References: <426FDEE8.1060408@digital-crew.com> Message-ID: <427004C8.7090209@inreach.com> Keith Gaughan wrote: > > It's useful in the short term, but in the long term not a good idea. We > are, unfortunately, at the mercy of fashion. ...and marketeering, yes. The "fasion" in our industry is mostly driven by marketing folks who are big on talking and "light" on technology. We've been given so many new "revolutionary" technologies that (I hope) we've become more sceptical of the hype by now. When the hype over New Technology X calms down and people start using it, we'll see whether it's got some value. Sometimes it does, but it's rarely as revolutionary as the hype suggests. I used to get nervous over all the new stuff I didn't have the time to learn but no more. I'll happily look at the next-to-latest stuff and see which ones are still around. /Mattias -- More views at http://www.thorslund.us From alan at timberon.com Wed Apr 27 19:45:43 2005 From: alan at timberon.com (Alan McGill) Date: Wed, 27 Apr 2005 19:45:43 -0500 Subject: [thelist] display message that Javascript is needed without Javascript Message-ID: <42703237.1040403@timberon.com> Hi all, I've been lurking and learning for a while. Thanks to all who contribute so much. My question seems like a catch 22. I've developed a page that has a message that the page needs javascript. Then I have a routine that runs onload to hide the message. Users with javascript enabled see the message till the page loads. I'm looking for a way to have users with javascript enabled not have to see the message at all. Any suggestions? TIA alan From syoung at unitec.ac.nz Wed Apr 27 19:59:07 2005 From: syoung at unitec.ac.nz (Stuart Young) Date: Thu, 28 Apr 2005 12:59:07 +1200 Subject: [thelist] Web Biz Message-ID: Of course every business should have a blog, as Zeldman quotes http://www.zeldman.com/daily/0305e.shtml The question isn't, "Should your business have a blog?" Of course your business should have a blog. The much more interesting question is, "Should your blog have a business?" Blogs are really good for SEO that's the main thing. Doesn't matter if no-one but the client ever reads it, google will be watching. Also, blogs are good for public relations in numerous ways on numerous levels. I'm also convinced that product update news should be published in blog format - people will move to receiving this via RSS rather than email updates. Blogs are also being extensively used in education for student personal reflective diaries. cheers -- Dr Stuart Young, +64 (0)9-815 4321 x 8656 +64 021 183 2846 (mob) Lecturer, School of Computing and Information Technology, Unitec New Zealand, Auckland, New Zealand http://tinyurl.com/4956o (the official URL for my staffpage is too long and complex) http://www.pixelandgrain.co.nz/ Web development, graphic design and photography >>> headlemur at lemurzone.com 23/04/2005 03:56:49 >>> Over the last few days a number of you have indicated that business is getting better. This is of course great news. Of this web work, are there any of you that are being approached about setting up blogs(weblogs) for clients? Are there any of you that are using blogs as your front door or as an adjunct to your web business? Is it working? alan herrell - the head lemur http://theheadlemur.typepad.com/ravinglunacy/ -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! From skilic at gmail.com Wed Apr 27 20:13:57 2005 From: skilic at gmail.com (=?ISO-8859-9?Q?Serdar_K=FDl=FD=E7?=) Date: Thu, 28 Apr 2005 11:13:57 +1000 Subject: [thelist] display message that Javascript is needed without Javascript In-Reply-To: <42703237.1040403@timberon.com> References: <42703237.1040403@timberon.com> Message-ID: <9bff278605042718133b4fe3b@mail.gmail.com> You can use On 4/28/05, Alan McGill wrote: > > Hi all, > > I've been lurking and learning for a while. Thanks to all who contribute > so much. > > My question seems like a catch 22. > I've developed a page that has a message that the page needs javascript. > Then I have a routine that runs onload to hide the message. Users with > javascript enabled see the message till the page loads. I'm looking for > a way to have users with javascript enabled not have to see the message > at all. > > Any suggestions? > > TIA > alan > -- > > * * Please support the community that supports you. * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip Harvester > and archives of thelist go to: http://lists.evolt.org > Workers of the Web, evolt ! > -- Cheers, Serdar Kilic http://weblog.kilic.net/ From keith at digital-crew.com Wed Apr 27 20:14:23 2005 From: keith at digital-crew.com (Keith Gaughan) Date: Thu, 28 Apr 2005 02:14:23 +0100 Subject: [thelist] display message that Javascript is needed without Javascript In-Reply-To: <42703237.1040403@timberon.com> References: <42703237.1040403@timberon.com> Message-ID: <427038EF.2020909@digital-crew.com> Alan McGill wrote: > Hi all, > > I've been lurking and learning for a while. Thanks to all who contribute > so much. > > My question seems like a catch 22. > I've developed a page that has a message that the page needs javascript. > Then I have a routine that runs onload to hide the message. Users with > javascript enabled see the message till the page loads. I'm looking for > a way to have users with javascript enabled not have to see the message > at all. Look up the