RE: lingo-l sql db dipping
AFAIK, SQL is not a db unless you are talking about Microsoft SQL Server... SQL is a scripting language used to gather info from the databases. Valentina only talks to valentina databases, the same is true with arca... The file that is on the local network, what format is it in? Comma separated, MS access, filemaker? Also, can you go through an import process, or will the db need to be used 'on the fly.' This will probably help determine which xtra to use... HTH, ~Mathew -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of grimmwerks Sent: Friday, September 12, 2003 11:28 AM To: [EMAIL PROTECTED] Subject: lingo-l sql db dipping So what has everyone used to read sql data into director? Luckily in this case it's a file on a local network being read by one application rather than supporting a consumer application over the web, so i'm thinking the new Arca might be fine, but in the chance that it could go consumer downloads I'm checking up on updatestage as to what other xtras do sql...and I'm sort of confused by the descriptions - ie Valentia - does it talk directly to a sql db? [To remove yourself from this list, or to change to digest mode, go to http://www.penworks.com/lingo-l.cgi To post messages to the list, email [EMAIL PROTECTED] (Problems, email [EMAIL PROTECTED]). Lingo-L is for learning and helping with programming Lingo. Thanks!]
Re: lingo-l sql db dipping
On Friday, September 12, 2003, at 11:49 AM, Mathew Ray wrote: AFAIK, SQL is not a db unless you are talking about Microsoft SQL Server... I understand what you're saying; I think in this case it IS Microsoft SQL. SQL is a scripting language used to gather info from the databases. Valentina only talks to valentina databases, the same is true with arca... The file that is on the local network, what format is it in? Comma separated, MS access, filemaker? Also, can you go through an import process, or will the db need to be used 'on the fly.' This will probably help determine which xtra to use... I'm in the process of finding out the format, but here's the big problem, and why I might have to veer to a 'true' sql SERVER situation rather than reading in a flat file. It's got to happen on the fly, but the db has to be polled with a timeout object for changes; the db is being fed from an rss feed, and I'm to update changes within the db. My first thought was the translating of the rss feed into a sql db kind of helped me, but there's part of me that thinks perhaps I should just parse the rss feed - like use a flash object xml socket or something...but that would make my job a bit harder as the feed is a bit of a mess. [To remove yourself from this list, or to change to digest mode, go to http://www.penworks.com/lingo-l.cgi To post messages to the list, email [EMAIL PROTECTED] (Problems, email [EMAIL PROTECTED]). Lingo-L is for learning and helping with programming Lingo. Thanks!]
RE: lingo-l sql db dipping
Yeah, IMO, Flash would be easier, since lots of stuff has already been designed to to ~exactly~ what you mentioned: reading RSS feeds. Sorry I don't have any examples offhand, but I am sure you can find some looking at flashcoders or just by looking at some of those peoples' blogs. You could also have director do the xml parsing if you feel like it :0) ~Mathew -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of grimmwerks Sent: Friday, September 12, 2003 12:24 PM To: [EMAIL PROTECTED] Subject: Re: lingo-l sql db dipping On Friday, September 12, 2003, at 11:49 AM, Mathew Ray wrote: AFAIK, SQL is not a db unless you are talking about Microsoft SQL Server... I understand what you're saying; I think in this case it IS Microsoft SQL. SQL is a scripting language used to gather info from the databases. Valentina only talks to valentina databases, the same is true with arca... The file that is on the local network, what format is it in? Comma separated, MS access, filemaker? Also, can you go through an import process, or will the db need to be used 'on the fly.' This will probably help determine which xtra to use... I'm in the process of finding out the format, but here's the big problem, and why I might have to veer to a 'true' sql SERVER situation rather than reading in a flat file. It's got to happen on the fly, but the db has to be polled with a timeout object for changes; the db is being fed from an rss feed, and I'm to update changes within the db. My first thought was the translating of the rss feed into a sql db kind of helped me, but there's part of me that thinks perhaps I should just parse the rss feed - like use a flash object xml socket or something...but that would make my job a bit harder as the feed is a bit of a mess. [To remove yourself from this list, or to change to digest mode, go to http://www.penworks.com/lingo-l.cgi To post messages to the list, email [EMAIL PROTECTED] (Problems, email [EMAIL PROTECTED]). Lingo-L is for learning and helping with programming Lingo. Thanks!]