Re: Structures No? Cached Queries Yes?

2000-08-31 Thread Andy Peterson
Message - From: paul smith <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 31, 2000 11:03 AM Subject: RE: Structures No? Cached Queries Yes? > I got the difference down to 15% by eliminating CFSETs > in the Structure version. (Structure still sl

RE: Structures No? Cached Queries Yes?

2000-08-31 Thread Jeremy Allen
You mentioned eliminating CFSET's is that the actually initalization of the structures? its not going to be very fair to do a cached query just pulling data versus setting and pulling the data.. im assuming that is what you mean by eliminating cfsets in the structure version. Also I n

RE: Structures No? Cached Queries Yes?

2000-08-31 Thread paul smith
Thanks! In an entirely different Structure/Cached Query application comparison from the one where I earlier today posted the code here, I'm seeing Structures are still 15% slower. Dave Watts opined here that he didn't believe there really was a limit to how many queries CF would cac

Re: Structures No? Cached Queries Yes?

2000-08-31 Thread Billy Cravens
ewww... I hate long blocks of cfset's :) Use cfscript instead when you have all those cfsets.. that'll speed things up some more. Additionally, a question: I've never had any problems with just sticking data in a structure, but without "creating" the structure using StructNew().. does anyone k

RE: Structures No? Cached Queries Yes?

2000-08-31 Thread dougn
>>>Thanks! In an entirely different Structure/Cached Query application comparison from the one where I earlier today posted the code here, I'm seeing Structures are still 15% slower. Without doing tests, I believe this is going to be the case. Structures are more efficient f

RE: Structures No? Cached Queries Yes?

2000-08-31 Thread Hinojosa, Robert
, Robert Hinojosa WebDeveloper 512.912.3775 [EMAIL PROTECTED] www.cirrus.com -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 31, 2000 12:31 PM To: [EMAIL PROTECTED] Subject: Re: Structures No? Cached Queries Yes? ewww... I hate long blocks of cfset&#

RE: Structures No? Cached Queries Yes?

2000-08-31 Thread Nilufer
Structure is more faster than query for example if you want to create a shopping cart, all information is saved in memory and you can add, delete, update structures to change items and it is much faster than saving items in database. Cache query may be faster only for display. At 09:38 AM 8/31

RE: Structures No? Cached Queries Yes?

2000-08-31 Thread paul smith
wrote: >You mentioned eliminating CFSET's >is that the actually initalization >of the structures? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion

RE: Structures No? Cached Queries Yes?

2000-08-31 Thread paul smith
Which is less efficient? I re-ran my test with and saw no statistically significant difference. best, paul At 12:48 PM 8/31/00 -0400, you wrote: >Also I notice from the structure version you use >APPLICATION.YPS["#Class_ID#"]["Pages"] IS "C"> > >and then in the Query version you use > > > >Al

RE: Structures No? Cached Queries Yes?

2000-08-31 Thread paul smith
The purpose of my posting was a heads up to those folks who really know how to do this sort of thing. But what I have done is a valid indicator for my app. That is, I was attempting to hold all things constant except how the data was stored in/read from memory. In addition, consider the followi

RE: Structures No? Cached Queries Yes?

2000-09-01 Thread paul smith
In my case it is fair, since I'm only interested in reads. Structures are widely touted as a way to store a DB in memory to speed things up. I was surprised to find results that suggested a cached query was faster. BTW, note that if this result is valid, it means stored procedures are

Re: Structures No? Cached Queries Yes?

2000-09-01 Thread paul smith
Interesting. FindNoCase had an effect on the Structure but not the Cached version. Structure still slower, 194/180 = 8% instead of 15%. best, paul At 11:42 AM 8/31/00 -0500, you wrote: >As an aside, I'd be curious to know how FindNoCase would affect processing >time if you replaced "eq" and "

Re: Structures No? Cached Queries Yes?

2000-09-01 Thread paul smith
This came up in the last two days. Check the archives. best, paul At 12:31 PM 8/31/00 -0500, you wrote: >Additionally, a question: I've never had any problems with just >sticking data in a structure, but without "creating" the structure using >StructNew().. does anyone know what the implicati

Re: Structures No? Cached Queries Yes?

2000-09-01 Thread paul smith
These CFSETs are one-time, when App is first accessed. Their ms is not included in the timings I posted. best, paul At 12:31 PM 8/31/00 -0500, you wrote: >ewww... I hate long blocks of cfset's :) > >Use cfscript instead when you have all those cfsets.. that'll speed >things up some more. > > >

RE: Structures No? Cached Queries Yes?

2000-09-01 Thread Ed Toon
Try CompareNoCase. ;) -Original Message- From: paul smith [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 31, 2000 2:40 PM To: [EMAIL PROTECTED] Cc: Andy Peterson Subject: Re: Structures No? Cached Queries Yes? Interesting. FindNoCase had an effect on the Structure but not the

RE: Structures No? Cached Queries Yes?

2000-09-01 Thread Ed Toon
Brief test. I doubted, so I tried. At first I was a little misled... then realized I wasn't testing properly. ;) Don't try doing this with a loops... loops throw it off. And be sure to reset the ticks between each test. CFSET x = 1 times: 1 cfset: 0 milliseconds 10 cfsets: 0 milliseconds 100 cfse

RE: Structures No? Cached Queries Yes?

2000-09-01 Thread Sharon DiOrio
on the queries vs. structures discussion you're comparing apples and oranges. If you have data that you're going to loop over and output, use a query. That's what they're designed for. But if you're going to call individual pieces of data (particularly organizati

RE: Structures No? Cached Queries Yes?

2000-09-01 Thread paul smith
ped queries. Essentially the same >thing, but I like managing my own caching rather than allowing the server >to determine what gets cached (based on the rotating list of "last used"). >Just a preference. > >But on the queries vs. structures discussion you're compari

RE: Structures No? Cached Queries Yes?

2000-09-01 Thread Sharon DiOrio
It would depend a lot on how you're using the information now, that is, how people are accessing it. Structures (particularly nested structures) are great for drill down information. But if you're doing a lot of looping, then queries might be faster. What might work is the nested

inserting cf structures into many tables

2000-09-18 Thread RICHARD MOGER
o the same database table, see example. What is the recommended limit for inserts using cftransction, the structures that I want to insert en masse could total maybe 40 insert queries, is this too much! I've also considered keeping the next table id numbers for a given application s

WebServices and Structures containing a Query

2003-06-25 Thread Brook Davies
Hello, I'm going to get around to testing this later, but I wonder if anyone knows off the top of their head: Prior to Updater 3, CFMX was unable to use webservice (communication between 2 CFMX Servers) with a Query/RecordSet inside of a key in a Structure. Does anyone know if this has been fi

Re: treating queries as structures/array

2003-06-26 Thread Jerry Johnson
for a query named qNames where columnList="id,name,car" Does this help at all? Jerry Johnson >>> [EMAIL PROTECTED] 06/26/03 04:10PM >>> Instead of me pasting code and trying to explain problem - could somebody give me the breakdown on treating query objects a

RE: treating queries as structures/array

2003-06-26 Thread Cantrell, Adam
- > From: Cantrell, Adam > Sent: Thursday, June 26, 2003 3:11 PM > To: '[EMAIL PROTECTED]' > Subject: treating queries as structures/array > > > > Instead of me pasting code and trying to explain problem - > could somebody give me the breakdown on treating query

RE: treating queries as structures/array

2003-06-26 Thread Cantrell, Adam
the conversion to a list. What am I missing? Adam. > -Original Message- > From: Cantrell, Adam [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 26, 2003 3:11 PM > To: CF-Talk > Subject: treating queries as structures/array > > > Instead of me pasting code and try

Re: treating queries as structures/array

2003-06-26 Thread jon hall
ariables4.html CA> (I know that's from the docs, but it took a search for me to find it - hence CA> the domain) CA> Adam. >> -Original Message- >> From: Cantrell, Adam >> Sent: Thursday, June 26, 2003 3:11 PM >> To: '[EMAIL PROTECTE

RE: treating queries as structures/array

2003-06-26 Thread Jim Davis
> Instead of me pasting code and trying to explain problem - could somebody > give me the breakdown on treating query objects as structures/arrays one > more time - like referring to records and columns using array notation, > etc. > There has to be an online resource that

Re: Lists vs. Arrays vs. Structures

2002-12-07 Thread Michael Dinowitz
ver > overhead each operation incurs and a list has the lowest overhead per > operation. You only want to use arrays or maps (structs) when you > require random access to the data. Arrays tend to be a good way of > representing different types of trees, which generally are the best data >

Re: Lists vs. Arrays vs. Structures

2002-12-09 Thread Zac Spitzer
tree tag in cf? lets talk examples... do you modify the array, ( ie inserting or deleting array members other than from the end?) if not then u could index the array using structures item_array=ArrayNew(1); item_struct=StructNew(); x

Re: Lists vs. Arrays vs. Structures

2002-12-09 Thread Michael Dinowitz
aketree tag in cf? lets talk > examples... > > do you modify the array, ( ie inserting or deleting array members other > than from the end?) if not then u could index the array using structures > > > item_array=ArrayNew(1); > item_struct=StructNew(); > > >

RE: Lists vs. Arrays vs. Structures

2002-12-09 Thread Matt Liotta
If I understand you correctly, you are representing a hierarchical relationship in a tabular manner. If there is another way you can store this information I would suggest it highly as there are many data structures much better suited for storage of hierarchical information. For example, a tree

Re: Lists vs. Arrays vs. Structures

2002-12-09 Thread Zac Spitzer
Michael Dinowitz wrote: > You can see the code here: > http://www.houseoffusion.com/_library/maketree.txt > Your example will fail as there can be more than one item with the same > 'parent', which is what we're looking for. No matter what, we have to do a > search and the list search functions see

RE: Lists vs. Arrays vs. Structures

2002-12-09 Thread Jeffry Houser
there is another way you can store >this information I would suggest it highly as there are many data >structures much better suited for storage of hierarchical information. >For example, a tree would give you O(log N) vs. your current O(N) >performance. As you can see, if N is large it ma

RE: Lists vs. Arrays vs. Structures

2002-12-09 Thread Matt Liotta
tara Software, Inc. http://www.montarasoftware.com/ 888-408-0900 x901 > -Original Message- > From: Jeffry Houser [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 09, 2002 7:59 PM > To: CF-Talk > Subject: RE: Lists vs. Arrays vs. Structures > > As an aside to this co

Re: Lists vs. Arrays vs. Structures

2002-12-09 Thread Dick Applebaum
On Monday, December 9, 2002, at 05:53 PM, Matt Liotta wrote: > I highly recommend people look into a hierarchical engine for handle > hierarchical information. > > Any suggestions, recommendations? TIA Dick ~| Archives: http:/

RE: Lists vs. Arrays vs. Structures

2002-12-09 Thread Matt Liotta
dent & CEO Montara Software, Inc. http://www.montarasoftware.com/ 888-408-0900 x901 > -Original Message- > From: Dick Applebaum [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 09, 2002 10:00 PM > To: CF-Talk > Subject: Re: Lists vs. Arrays vs. Structures > > On

RE: Sorting an array of structures

2002-08-26 Thread Raymond Camden
Yahoo IM : cfjedimaster "My ally is the Force, and a powerful ally it is." - Yoda > -Original Message- > From: Paolo Cesana [mailto:[EMAIL PROTECTED]] > Sent: Monday, August 26, 2002 9:37 AM > To: CF-Talk > Subject: Sorting an array of structures > > >

Using Structures with Arrays, Please Help

2002-04-03 Thread Burcham, Steve
Can anyone see anything wrong with this code? I am trying to loop through data to find the Sales Persons login id and for each sales person return the activities, dates, contacts, etc. for them to see. The error is listed below. There are two pages to this. The first page goes out and retrieve

Structures and Arrays and Memory Usage

2000-06-04 Thread Tim Dempsey
ete all of the structures that were constructed for a page after it is analyzed and before the next page is begun? Or is that not necessary? Can anyone enlighten me? Thanks, -- Tim Dempsey -- Archives: http://www.eGroup

RE: Structures vs. Scopes: Difference is?

2000-07-25 Thread Steve Martin
Session, URL, form, etc variables e.g. FORM.MyVar is a variable stored in the FORM scope. It just happens thas as from CF4.5 all FORM, URL, SESSION, APPLICATION, COOKIE (etc.) scoped variables are stored as structures such that you can use the various structure functions on them. Before

RE: Problem using structures with SOAP...

2004-02-10 Thread Tom Jordahl
Jordahl Macromedia From: Chris Rice [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 10, 2004 5:19 AM To: CF-Talk Subject: Problem using structures with SOAP... Hi everyone, I'm new to this list and I have a problem which is seriously holding ba

OT: MS SQL - Exporting table structures

2002-05-20 Thread Paul Giesenhagen
I have seen this in MySQL editors, but does MS SQL have an export feature that will export the table structures and such or an export that builds the CREATE TABLE syntax for a list of tables. Any help would be great! Paul Giesenhagen QuillDesign

RE: MS SQL - Exporting table structures

2002-05-20 Thread Ken Beard
yeah i think it's called "generate sql scripts" or something like that... enterprise manager -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 11:31 AM To: CF-Talk Subject: OT: MS SQL - Exporting table structures I have see

RE: MS SQL - Exporting table structures

2002-05-20 Thread Won Lee
CTED]] >Sent: 20 May 2002 16:41 >To: CF-Talk >Subject: RE: MS SQL - Exporting table structures > > >yeah i think it's called "generate sql scripts" or something like that... >enterprise manager > > >-Original Message- >From: Paul Giesenhagen [m

RE: Nested Structures and Arrays - Addendum

2000-11-16 Thread Eric Gilbert
YER.ADDRESS" in dimension 1 of object "Session.Intake.Guardian" cannot be found. Please, modify the member name" -Original Message- From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 16, 2000 7:17 AM To: CF-Talk Subject: RE: N

RE: Nested Structures and Arrays - Addendum

2000-11-16 Thread Robert Segal
both work. -Original Message- From: Eric Gilbert [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 16, 2000 11:35 AM To: CF-Talk Subject: RE: Nested Structures and Arrays - Addendum Sorry I miss typed the code, what I meant was Session.Intake = struc

RE: Nested Structures and Arrays - Addendum

2000-11-16 Thread Sima . Lee
Hi Eric, The code looks OK to me. A structure in CF is really an associated array, and Cf only support for three dimensional arrays. Your code nested four structures, so I am not sure if this is the problem. But I remember in the CF advanced training course the instructor said by creating

RE: Nested Structures and Arrays - Addendum

2000-11-17 Thread DeVoil, Nick
tesimally quicker for CF to parse? Nick -Original Message- From: Eric Gilbert [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 16, 2000 4:35 PM To: CF-Talk Subject: RE: Nested Structures and Arrays - Addendum Sorry I miss typed the code, what I meant was Session.Intake =

RE: Nested Structures and Arrays - Addendum

2000-11-17 Thread Sima . Lee
"DeVoil, Nick"To: CF-Talk <[EMAIL PROTECTED]> Subject: RE: Nested Stru

What's the use of structures, anyway?

2000-04-20 Thread Reuben King
Structures seem totally useless to me. If they were two dimensional, then I could see definite value. I'd love to see something like: .. etc ... As I understand it right now from reading the CF docs and Forta's books, structures are nothing at all but a one dimensional

How to create Array of Structures

2000-05-12 Thread Ajoy Singh
Hi all, How do we create Array of Structures in ColdFusion? As an example I have a query to get the list of employees and I need to create it as an array of structures. How do you populate data and how can we retrieve it? Example Query: select ssn, firstName, lastName from employee Thanks, Ajoy

CFPARAM, structures and array style notation

2001-09-09 Thread Aidan Whitehall
This works... but this throws an error ("Invalid token found on line 2 at position 41" - the apostrophe after LoggedIn)... This doesn't throw an error, but dumping the session variable to screen doesn't display a key called LoggedIn in the session variable... Is it possible to use the

Re[2]: Are forms really structures?

2001-11-13 Thread Critz
oi Critz!! Bah, nevermind mei'm half asleep still! -- Critter, MMCP Certified ColdFusion Developer Crit[s2k] - - Tuesday, November 13, 2001, 9:23:09 AM, you wrote: C> oi Kola!! C> I didn't think forms were a structure in versions LT 4.5 ? C> I

RE: Nested Structures and Arrays - Addendum

2000-11-17 Thread Eric Gilbert
Thanks All on your input array notation looks like the best route. I was using dot notation since I am familiar with it more than any other. Basically It would appear that my suspicion that it is a CF Language limitation is correct, but only specific to adding nested structures to arrays using

Re: Structures: Where is data kept

2000-11-25 Thread Michael She
I believe you have the option of storing session variables in the registry (not sure where) or in a specific datasource. At 09:47 AM 11/25/00 -0500, you wrote: >Once a structure has been created and populated, where is the data kept? I >can't find it in the registry anywhere but it persists ac

RE: Structures: Where is data kept

2000-11-25 Thread James McCullough
t out of the database and then serialize it into the structure. This is a good way to build a clusterable application that uses client variables or other structures for setting user preferences. HTH James McCullough -Original Message- From: Michael She [mailto:[EMAIL PROTECTED]] Sent: Sat

RE: Structures: Where is data kept

2000-11-25 Thread Bill Killillay
Session variables are stored in client side cookies and/or server memory. They DO NOT get stored in the registry. The variables that get stored in the registry are Client variables. There is a BIG difference in the two. For example you cant story a structure in a Client variable with out using

RE: Structures: Where is data kept

2000-11-25 Thread Dave Watts
> Session variables are stored in client side cookies and/or > server memory. They DO NOT get stored in the registry. The > variables that get stored in the registry are Client > variables. There is a BIG difference in the two. For > example you cant story a structure in a Client variable with

RE: Structures: Where is data kept

2000-11-25 Thread Bill Killillay
Then how would the persist across the reboots? > -Original Message- > From: Dave Watts [mailto:[EMAIL PROTECTED]] > Sent: Saturday, November 25, 2000 1:34 PM > To: CF-Talk > Cc: '[EMAIL PROTECTED]' > Subject: RE: Structures: Where is data kept > > &

RE: Structures: Where is data kept

2000-11-25 Thread Dave Watts
> > Session variables are NOT stored in client-side > > cookies. They're always > > stored in memory. What is stored in cookies are > > the two tokens CF uses to > > associate a user's browser with those variables > > stored in memory. > > Then how would the persist across the reboots? They do

RE: Structures: Where is data kept

2000-11-25 Thread Nick McClure
; Cc: '[EMAIL PROTECTED]' > > Subject: RE: Structures: Where is data kept > > > > > > > Session variables are stored in client side > > cookies and/or > > > server memory. They DO NOT get stored in the > > registry. The > > > varia

RE: Structures: Where is data kept

2000-11-25 Thread Bill Killillay
You know they don't and I know they don't, but earlier in this thread the gentleman said they where making it across "reboots". The only thing that would explain that is if the data was being held in a cookie. Now I guess the question is which machine is he talking about the reboot on. If it's

Re: Structures: Where is data kept

2000-11-25 Thread Bill Davidson
ry of the browser? Just a thought (or two..) -Bill /intraget - Original Message - From: Bill Killillay <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Sent: Saturday, November 25, 2000 4:26 PM Subject: RE: Structures: Where is data kept > You know they don't a

how to teach arrays and structures

2000-12-09 Thread Martin Orth
Hi, I need some good examples and explanations on how to teach coldfusion arrays and structures. maybe some drawings or illustrations. Please send any examples to [EMAIL PROTECTED] Thanks Martin -- Martin Orth - CFSOLUTIONS Oberblissenbach 30 - 51515 Kuerten Tel. 02207 700650 - [EMAIL

RE: record sets... arrays or structures?

2001-01-04 Thread Johan Coens
Try User[13].FullName, u can use that with recordsets. Structures work the same, and you have a tool called QueryToStruct, which converts your query to a structure. Regards, Johan Coens -Original Message- From: Mike Amburn [mailto:[EMAIL PROTECTED]] Sent: donderdag 4 januari 2001 15:03

Re: record sets... arrays or structures?

2001-01-04 Thread Joe Sheble aka Wizaerd
I've never had any difficulties in using this.. SELECT BLAH BLAH BLAH #qQuery.SomeField[10]# At 09:02 AM 1/4/01 -0500, you wrote: >subject says it all > >let's say a have a record set of users and wanted to get the first name >of row #13. could i use something like: > > Use

RE: record sets... arrays or structures?

2001-01-04 Thread Joe Sheble aka Wizaerd
This sytnax will not work with recordsets... the index of the array must come after the fieldname... At 03:13 PM 1/4/01 +0100, you wrote: >Try User[13].FullName, u can use that with recordsets. >Structures work the same, and you have a tool called QueryToStruct, which >converts your

RE: Storing structures in a DB

2001-04-25 Thread Craig Dudley
Try using a WDDX packet, you can store those as strings in a DB. -Original Message- From: Darren Adams [mailto:[EMAIL PROTECTED]] Sent: 25 April 2001 09:39 To: CF-Talk Subject: Storing structures in a DB Hello, Just a simple question that probably has a simple answer. Can a

RE: Storing structures in a DB

2001-04-25 Thread DeVoil, Nick
rge text field. Otherwise of course you can have a table with one column for each field in the struct. Nick -Original Message- From: Darren Adams [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 9:39 AM To: CF-Talk Subject: Storing structures in a DB Hello, Just a simple

RE: Storing structures in a DB

2001-04-25 Thread Darren Adams
I would normally use columns in a database and not worry about structures but, from the looks of the spec that I have got there is more of a complicated structure. basically it is a company information section for our intranet. Within the Slow_stream table there will be coluimns for Company

RE: Storing structures in a DB

2001-04-25 Thread Neil Clark
Darren, my advice would be to abandon the column approach and create a DB with some well defined columns then you can use XML/WDDX to store sructures which hold any kind of CF variable for manipulation. this way you have a re-usable DB which does not need to be redefined for everyjob - you could

RE: Storing structures in a DB

2001-04-25 Thread DeVoil, Nick
-Talk Subject: RE: Storing structures in a DB I would normally use columns in a database and not worry about structures but, from the looks of the spec that I have got there is more of a complicated structure. basically it is a company information section for our intranet. Within the Slow_stream

RE: Storing structures in a DB

2001-04-25 Thread Dick Applebaum
You may wish to spend a little time analyzing how these data are going to be accessed within the database. If you are going to (regularly) search/sort any of these data, then structures, wddx, large composite text fields are a poor choice. each column in the database should be atomic

RE: Storing structures in a DB

2001-04-25 Thread Darren Adams
Subject: RE: Storing structures in a DB You may wish to spend a little time analyzing how these data are going to be accessed within the database. If you are going to (regularly) search/sort any of these data, then structures, wddx, large composite text fields are a poor choice. each column

RE: Storing structures in a DB

2001-04-25 Thread Dick Applebaum
At 10:21 AM +0100 4/25/01, DeVoil, Nick wrote: >I think you'll save yourself a lot of trouble later if you >do a normalised database design with all necessary tables, >columns etc and access them individually. > >Nick > Great advice... the database should reflect the structure of the data, not

RE: Storing structures in a DB

2001-04-25 Thread Neil Clark
Agreed, but take the scenario of having to create a DB for every project with an avg development time of 5-6 weeks (for true testing); Object Based Development is the way forward, DB development thru XML is the future. N ~~ Structure your Col

RE: Storing structures in a DB

2001-04-25 Thread Dick Applebaum
Yes and no Say you have some data in a cf program say some arrays, simple variables, lists, and maybe even some structures. Now, you want to store all this in a single field (column) in a database. The easiest way is to create 1 big structure, serialize it into a wddx packet, and store the

RE: Storing structures in a DB

2001-04-25 Thread Dick Applebaum
You didn't post what you are agreeing to? What do you mean "DB development thru XML is the future" ? Dick At 10:59 AM +0100 4/25/01, Neil Clark wrote: >Agreed, but take the scenario of having to create a DB for every project >with an avg development time of 5-6 weeks (for true testing); Object

RE: Storing structures in a DB

2001-04-25 Thread Neil Clark
Well, data either stored as XML or defined by XML is the way DB's are going, there is not question about that. N ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: ht

RE: Storing structures in a DB

2001-04-25 Thread DeVoil, Nick
How does that speed up development time though? -Original Message- From: Neil Clark [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 11:25 AM To: CF-Talk Subject: RE: Storing structures in a DB Well, data either stored as XML or defined by XML is the way DB's are going,

RE: Storing structures in a DB

2001-04-25 Thread Darren Adams
That makes sense to me ! Thanks for your help folks -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: 25 April 2001 10:59 To: CF-Talk Subject: RE: Storing structures in a DB Yes and no Say you have some data in a cf program say some arrays, simple variables

RE: Storing structures in a DB

2001-04-25 Thread Dick Applebaum
At 11:25 AM +0100 4/25/01, Neil Clark wrote: >Well, data either stored as XML or defined by XML is the way DB's are going, >there is not question about that. Well, I haven't kept up on all the latest, but I think I can give you some current reasons and some historical perspective why XML may be

RE: Storing structures in a DB

2001-04-25 Thread Neil Clark
Image you have a DB and 1 table with say 3 fields - ID (GUUISD), Label, and a final one Properties (ntext) - you could potentially store all information you would need in this format using XML - you can then deserialise the data as you need it, many different types of information can be stored in

RE: Storing structures in a DB

2001-04-25 Thread Dick Applebaum
I agree that this is *an* excellent way to develop/prototype an database. However, the overhead is so significant, both in storage and processing that you probably would not want to use this in an operational environment. serialization/deserialization aside, how do you efficiently store and s

RE: Storing structures in a DB

2001-04-25 Thread Neil Clark
Easy, import / DTS the legacy information into your new DB schema and utilise Meta information to allow for searching capabilties - storage and processing should never come into it - if the DB is well designed along with the code; then the server should simply be doing its job - serving. as for

RE: Storing structures in a DB

2001-04-25 Thread Douglas Knudsen
04/25/2001 06:25 AM To: [EMAIL PROTECTED] AT INTERNET@CCMAIL cc:(bcc: Douglas Knudsen/ATL/ALLTELCORP) Subject: RE: Storing structures in a DB Well, data either stored as XML or defined by XML is the way DB's are going, there is no

RE: Storing structures in a DB

2001-04-25 Thread Neil Clark
Your reasoning? N ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/

RE: Storing structures in a DB

2001-04-26 Thread DeVoil, Nick
> as for normalizing; with a globally designed DB - it is not necessary; the logic is ported into the App. Well, sorry to bore people with this now slightly OT thread, but "there's the rub" - by storing all the data in one table you have thrown away all the inherent business-modelling capability

RE: Storing structures in a DB

2001-04-28 Thread Dave Watts
> > as for normalizing; with a globally designed DB - it is not > > necessary; the logic is ported into the App. > > Well, sorry to bore people with this now slightly OT thread, > but "there's the rub" - by storing all the data in one table > you have thrown away all the inherent business-modell

RE: Storing structures in a DB

2001-04-28 Thread Brook Davies
On the topic of relational tables: If I create a relational DB structure but do not define the relationship at the database level, is there a loss in performance when my application requests data from two tables based on the relationship. I guess what I'm asking is do you need to define the re

RE: Storing structures in a DB

2001-04-28 Thread Dave Watts
> If I create a relational DB structure but do not define the > relationship at the database level, is there a loss in performance > when my application requests data from two tables based on the > relationship. I guess what I'm asking is do you need to define > the relationship at the DB leve

Arrays and Structures storing query values

2001-04-30 Thread Darren Adams
Can anyone lend me a hand ? I am trying to store one database in an array of structures then insert it into another database. I am only using one field at the moment but, there will be 9 that I want to copy over. What I am trying to do is to take PressReleaseHeader from the pressreleasetable

CFMX + .Net: Data types (especially STRUCTures)

2004-08-04 Thread Hansjoerg Posch
truct type and to be honest I wasn't able to get things working with Visual Basic too (the returned structure is always empty). Other products, f.e. Borland Delphi 7 do not seem to have problems with structures. Best regards, Peter [Todays Threads] [This Message] [Subscription] [F

[structures] How would you do this?

2004-09-15 Thread Phill B
I'm trying to put some picture info into a variable that will be easy for the designers to use. I have to query a database to get specific images. I then tweak the results and want to put them into a variable similar to this. FeaturesOptions.image1.fileLocation = http://www.asdf.com/asdf.jpg Feat

RE: Structures (probably a stupid question)

2005-04-24 Thread Adrian Lynch
That'll get you an array of structures. One thing to note, unlike this... myStruct.myKey = "somevalue" which works in creating a struct, key and value... myArrayOfStructs[1].myKey = "somevalue" will fail with an

Re: Structures (probably a stupid question)

2005-04-24 Thread Sean Corfield
On 4/24/05, Thane Sherrington <[EMAIL PROTECTED]> wrote: > I'm trying to understand structures - I understand that they are like the > form scope in that I can access them as myStruct.myVar, but is there a way > to create an array of structures? myArray = arrayNew(1) my

RE: Structures (probably a stupid question)

2005-04-24 Thread Thane Sherrington
At 12:57 PM 24/04/2005, Adrian Lynch wrote: > > > > > > > > > > > > >That'll get you an array of structures. One thing to note, unlike this... Thanks for this - it's much clearer now. Now I can give it a shot in my app. T --- [This

Re: Structures (probably a stupid question)

2005-04-24 Thread Thane Sherrington
At 12:57 PM 24/04/2005, Sean Corfield wrote: >If you're just getting your head around this stuff, I strongly suggest >you buy Jeff Peters' book: "ColdFusion Lists, Arrays & Structures": > >http://www.protonarts.com/index.cfm?fuseaction=Books.showBookDet

RE: Structures (probably a stupid question)

2005-04-24 Thread Ewok
cture. Eg. -Original Message- From: Thane Sherrington [mailto:[EMAIL PROTECTED] Sent: Sunday, April 24, 2005 11:21 AM To: CF-Talk Subject: Structures (probably a stupid question) I'm trying to understand structures - I understand that they are like the form scope in that I can

RE: Structures (probably a stupid question)

2005-04-24 Thread Jim Davis
> -Original Message- > From: Thane Sherrington [mailto:[EMAIL PROTECTED] > Sent: Sunday, April 24, 2005 11:21 AM > To: CF-Talk > Subject: Structures (probably a stupid question) > > I'm trying to understand structures - I understand that they are like the > fo

Re: Structures (probably a stupid question)

2005-04-24 Thread Will Tomlinson
>At 12:57 PM 24/04/2005, Sean Corfield wrote: > >>If you're just getting your head around this stuff, I strongly suggest >>you buy Jeff Peters' book: "ColdFusion Lists, Arrays & Structures": >> Excellent advice. Jeff Peters' b

<    1   2   3   4   5   >