Nth Record Subset

2002-09-01 Thread Jim Gurfein
Hi List, All you gurus out there... I'm trying to find a way to select every nth record from a database that has 200,000 records. How would I go about setting up the SQL to select every 15th record ? Any and all help would be appreciated! Sincerely yours, Jim Gurfein President, CEO

Re: find mdb

2002-09-01 Thread S . Isaac Dealey
You could get a list of all mdb files within a given directory and all subdirectories via a script like this: cfset searchin = arraynew() cfset searchin[1] = expandpath() cfset x = 1 cfoutputcfloop condition=x lte arraylen(searchin) div#searchin[x]#/div cfdirectory action=list name=rssearch

CFMail - unix line style problem

2002-09-01 Thread Bartee Lamar
I have function where a user uploads an HTML file. This gets saved on server as a .txt file. User then requests this file to be mailed to a mailing list. I do cffile action=READ file=#fileDirectoryAndName variable=FileContents Then I send out the file with cfmail to= mailto:[EMAIL

Re: dynamic select boxes based on queries?

2002-09-01 Thread Jann VanOver
One old trick is to have a hidden (one pixel high) frame at the top or bottom of your screen. This frame can then be used for return trips to the server and the user sees nothing. The invisible Frame does the server work and refreshes itself (invisibly). Then you can use cross-window Javascript

Re: Still dead? - Mandarin versions...???

2002-09-01 Thread Brian Scandale
Cool... UnDead... now I have a question... I've been saving it for two days. I have an application... quite large actually. A potential customer asks me, do you have it in Mandarin? ...but of course I say. Now what the hell have I gotten myself into? Please... some direction on where to

Re: session time

2002-09-01 Thread Chris Norloff
That's a 30-day session timeout. It sounds like the timeout is a thread timing out, not the session. Chris Norloff -- Original Message -- from: Agus Setiawan Basuni [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Fri, 30 Aug 2002 08:36:55 +0700 I

UNSUBSCRIBE

2002-09-01 Thread Judith Dinowitz
Sorry. The email about the new unsubscribe system and how to get your password was supposed to go out but the system had a small problem. I've taken care of it for you. __ Your ad could be here. Monies from ads go to support

Re: Email lists

2002-09-01 Thread Jann VanOver
I know I'm late on this thread, and I hate spam like everyone BUT IF YOU MUST SPAM, here's what else I'd like: 1. a WEB PAGE to opt out, not a return email, with the email used for me is already filled into the form (so I don't have to look at the mail headers to see which email address it

Re: UNSUBSCRIBE

2002-09-01 Thread Ewok
try the unsubscribe link at the bottom of all CT_Talk email - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, August 30, 2002 8:36 AM Subject: UNSUBSCRIBE Alan Walter Intranet Application Development (MBAE51) * Office: 020 7929 2423 *

looping through array

2002-09-01 Thread Tony Weeg
hi there... lets say I have a list: 1,2,4,6 and I drop those values into an array cfset CurrentSwitches=ArrayNew(1) and then I want to loop through that array to output this select name=SwitchNumber option value=3 option value=5 option value=7 option value=8

SQL Sybase error after upgrading from 4.5 to 5.0

2002-09-01 Thread Angel Stewart
Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = IM004 (Driver's SQLAllocEnv failed) [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed The error occurred while processing an element with a general identifier of

Re: Authenticating on a mail server through CF5

2002-09-01 Thread samcfug
I use imail7 on my mail server and it is easy enough to allow relaying via CFMAIL. It is done via custom header as opposed to the less secure IP number.. I have another server that runs on Linux/Sendmail, however it also is set up to require SMTP-AUTH as do most mail servers. The reason for

Re: Still dead? - Mandarin versions...???

2002-09-01 Thread Paul Hastings
I've been poking around various lists and texts but nothing that says... Here are the N plus Steps one goes through to provide an application in some other language. depends entirely on how your original app was developed. most likely its not i18n ready (few are). what ver of cf? is the app

CFMX :: URLSessionFormat :: J2EE

2002-09-01 Thread Bill Davies
Has anyone on the list experienced a problem with the J2EE session ID appended by URLSessionFormat()? On the server in question (Win2k SP3, IIS 5) you end up with links that look like: myPage.cfm;JSESSIONID=8030949691025145133137?myVar=myVal which then throws a 404 error. Any suggestions

Re: UNSUBSCRIBE

2002-09-01 Thread Michael Dinowitz
I will have a new link installed on the bottom of all messages to allow people to unsubscribe with a single press of a button. It's being tested now. try the unsubscribe link at the bottom of all CT_Talk email - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL

Query resuts into structure

2002-09-01 Thread James Mathieson
Easy question for the gurus. I have a query that grabs a set of products associated with an ID (to autofill a cart for a person's renewal) - product_code, description, cost (quantity not needed on this part, as you wouldn't want to join twice at once). I've been hunting the CFWACK and the Studio

cfmx - internal server error 500

2002-09-01 Thread Ken Beard
anybody get this error is a mysterious kinda fashion? i don't know what's causing it but the code looks fine. of course i get no line number or anything with this, but the file is REALLY simple.. actually it's happened on a few. persistent, not inconsistent. input appreciated.. suppose this

Re: looping through array

2002-09-01 Thread Douglas Brown
cfset excludeList = 1,4,5,7 select name=test cfloop from=1 to=10 index=i cfif listContains(excludeList, i) cfelse cfoutput option value=#i##i# /cfoutput /cfif /cfloop /select - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, August 30,

(Admin) Sorry

2002-09-01 Thread Michael Dinowitz
I was working on the system last night/this morning to alleviate some of the delays we've been seeing. In some ways the new system was great but in others it had some problems. I've flipped back to the old system. Sorry for the problems. I'll try again with new code over the weekend. Michael

CFMX and Oracle

2002-09-01 Thread Hamad Amaral
Hi All, I experienced some problems with CFMX and Oracle. After install CFMX my procedures can't run, and DBA says that the session is in wait statr and the event catched by v$session_wait is SQL*Net more data from client. Datasource, SID Name and Server are OK and other database operations

RE: Flash Rich App Approach = Macromedia?

2002-09-01 Thread Benoit Hediard
I am also not very convinced. They don't seem to have many differentiators vs MX (except that they don't use Flash Authoring tool). I wonder how they will compete with Macromedia. We will see when they'll release their techno by the end of the year. Flash Authoring tool might not be yet the

Re: CFAdmin Log Question

2002-09-01 Thread Chris Norloff
The web server logs may have a more complete 404 error listing. Chris Norloff -- Original Message -- from: [EMAIL PROTECTED] (Rafael (Alan Bleiweiss)) Reply-To: [EMAIL PROTECTED] date: Thu, 29 Aug 2002 22:10:08 -0400 Now that I'm working on dealing with

RE: Flash Rich App Approach = Macromedia?

2002-09-01 Thread Benoit Hediard
Macromedia publish the specifications for SWF since April 1998 (http://www.openswf.org). So if you follow those specifications, you should not have any problems. Till now, when MM releases a new version of Flash, MM always try to have a downward-compatibility with the new player. For example, you

Re: http://examples.macromedia.com/coldfusion/examples/ down??

2002-09-01 Thread Sean A Corfield
Thanx for letting me know. I'll get someone to look at it as soon as I get into the office this morning. On Thursday, August 29, 2002, at 11:01 , Chris Kief wrote: FYI...Sean or anybody else from MM listening in... It seems all the examples are no longer working on the CF examples site (as

Why am I now getting this

2002-09-01 Thread Cathy Taylor
Every hour with a lot of undeliverable error messages? It kind of defeats the purpose of subscribing to the digest. Did the list options change? Thanks! Catherine Taylor __ Signup for the Fusion Authority news alert and keep

Intellisync

2002-09-01 Thread Nick McClure
Anybody here have any experience working with Intellisync and a CF application? I have a client who wants to sync the calendar app, which we built, with his Palm handheld. He uses the Palm desktop so it would need to work with that. Anybody done this before? What can I expect?

test

2002-09-01 Thread Michael Dinowitz
test Michael Dinowitz Master of the House of Fusion http://www.houseoffusion.com __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community.

CFMX - System Probes

2002-09-01 Thread Chris Stoner
It seems that CFMX has lost the ability to tie in with a load balancer ( im using an alteon ace director 4), most importantly restrict access to a specific server from a server probe. Am I missing something or is this true? Does anyone have a work around? My only thoughts are to use a probe to

Re: CF+MSACCESS+Unicode?

2002-09-01 Thread Roberts Freimuts
I can get Unicode characters into CFML documents by setting the coding to utf-8. what version of cf? pre-mx cf didn't do such a good job w/unicode. HOWEVER when I execute a ColdFusion Query most non ASCII characters (Latvian, Estonian, Livonian, Cyrillic) come back as question marks

Re: Nth Record Subset

2002-09-01 Thread Jochem van Dieten
Jim Gurfein wrote: Hi List, All you gurus out there... I'm trying to find a way to select every nth record from a database that has 200,000 records. How would I go about setting up the SQL to select every 15th record ? If you have some consecutive number use the MOD operator in your

Nth Record Selection Set

2002-09-01 Thread Jim Gurfein
Hi List, Sorry for sending this again, but the list was having problems All you gurus out there... I'm trying to find a way to select every nth record from a database that has 200,000 records. How would I go about setting up the SQL to select every 15th record ? Any and all help would be

Re: Security test for shared server environments

2002-09-01 Thread Jochem van Dieten
Gyrus wrote: We've just set up as resellers with a new host, and we're on a 30-day trial period, during which we hope to fully guage the stability and security of the environment. Do any of you have a standard set of CF test for checking out the security of a shared hosting environment?

Re: Nth Record Selection Set

2002-09-01 Thread Jesse Houwing
Jim Gurfein wrote: Hi List, Sorry for sending this again, but the list was having problems All you gurus out there... I'm trying to find a way to select every nth record from a database that has 200,000 records. How would I go about setting up the SQL to select every 15th record ?

Re: ColdFusion MX Certification Beta Exam

2002-09-01 Thread S . Isaac Dealey
It droped my score as well but i didnt study CMFX stuff to take the test... and havent been coding any CFMX stuff.. but this is what i thought. The same was true for myself. 1. Fairly ok Test. 2. Some repeat questions. 3. Some questions code was the answer the next question. what up

Re: Cold Fusion MX Flash MX Applications

2002-09-01 Thread S . Isaac Dealey
I've been getting a lot of bounces the past several days... Actually, I'd say close to 80-90% of my messages to the list... I figured Mike was working on that since I saw him sending test messages... Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 This bounced

RE: Standard SQL to get a Table List ?

2002-09-01 Thread S . Isaac Dealey
-Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 4:17 PM To: CF-Talk Subject: Standard SQL to get a Table List ? Is this specific to each vendor? (accessing system tables or what not) Anyway to do this with standard SQL ? Yes, every

Re: dynamic select boxes based on queries?

2002-09-01 Thread S . Isaac Dealey
No need to go to this extent ... there's a custom tag on the devex called TwoSelectsRelated that does it without a round trip ... Or you can write it yourself in JS with grouped output... You just have to make sure that you have all the data on the form page, which of course has the potential to

Re: looping through array

2002-09-01 Thread S . Isaac Dealey
cfset excludeList = 1,4,5,7 select name=test cfloop from=1 to=10 index=i cfif listContains(excludeList, i) cfelse cfoutput option value=#i##i# /cfoutput /cfif /cfloop /select I probably shouldn't say anything, but, you're probably better of if you're not putting anything between the

Re: Authenticating on a mail server through CF5

2002-09-01 Thread S . Isaac Dealey
.. How is an email header that anyone can read off of the email more secure than the IP address of the CF Server? Or does iMail allow you to strip the header before it goes out? Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 I use imail7 on my mail server and it

RE: URL Parameter?

2002-09-01 Thread Dave Watts
URL parameters are passed as part of the URL, for example: http://Testsite.com/index.cfm?strParam=This_is_a_sample_URL_Param; When your CF program is called, this field would have the fully qualified name of url.strParam Just a little note - neither spaces nor double quotes are

RE: Evaluate???

2002-09-01 Thread Dave Watts
Basically what i need to do is make a Valulist out of QueryName.DynamicPrimaryKey cfset list = Valuelist(QueryName.ATTRIBUTES.PrimaryKey) ATTRIBUTES.Column is named dynamically and ive used Evaluate(ATTRIBUTES.PrimaryKey) numerous times in this template but this one I can't seem to get

RE: Pages not found SiteWide Handler

2002-09-01 Thread Dave Watts
What I do is set up a site-wide missing template handler (In the cold fusion admin) that points to a file that contains the following script ... Al, this is great however I don't know where in the CFadmin to set this up... I don't see anywhere to add handlers... It's in the Settings

RE: programmer vs. developer

2002-09-01 Thread Dave Watts
The good doctors, lawyers or plumbers keep up with whats current. Those who don't fail. There's a difference between keeping current and constant work. In fact, most programmers don't keep current, even when they're working insane hours - they're simply doing more work. In fact, I think

RE: Flash Rich App Approach = Macromedia?

2002-09-01 Thread Dave Watts
Very interesting strategy -- to leverage the existence of the Flash plug-in without requiring Flash as a programming tool -- How much of the Flash interface is a published standard not subject to change? If the interface is not a published standard, then this approach is headed

Re: SQL Sybase error after upgrading from 4.5 to 5.0

2002-09-01 Thread S . Isaac Dealey
This errror is described as an implementation specific problem with ODBC... Unfortunately I don't think rewriting any of the queries will help, since Microsoft describes it as a connection failure. I wish there were more I could do to help... sorry...

Re: Nth Record Subset

2002-09-01 Thread S . Isaac Dealey
Jim Gurfein wrote: Hi List, All you gurus out there... I'm trying to find a way to select every nth record from a database that has 200,000 records. How would I go about setting up the SQL to select every 15th record ? If you have some consecutive number use the MOD operator in your

Re: Nth Record Selection Set

2002-09-01 Thread S . Isaac Dealey
Jim Gurfein wrote: Hi List, Sorry for sending this again, but the list was having problems All you gurus out there... I'm trying to find a way to select every nth record from a database that has 200,000 records. How would I go about setting up the SQL to select every 15th record ?

Re: Flash Rich App Approach = Macromedia?

2002-09-01 Thread Dick Applebaum
Ben Took the Altio tour -- quite well done and loaded quickly. It was a Flash movie. Tried to run their demos -- would not run on a Mac. This is surprising, because they state: Requires no client-side installation, downloads or plug-ins User settings are preserved across all sessions for

RE: Prefix Thoughts

2002-09-01 Thread Dave Watts
This - and similar systems - are often known as Hungarian Prefix Notation and they are *evil*... Sean, I hate to keep this thread living, but I had a question about it again. I know you think that Hungarian Notation is of the devil, but what about Macromedia encouraging the use of

RE: programmer vs. developer

2002-09-01 Thread Dave Watts
I'm surprised to see such a response from you. You're one of the few people I see on this list 24/7. I'm on the west coast and see you post at 12:42am. If memory serves me correctly you're on the east coast... 3:42am You got up early to go fishing didn't you? ;-) White-water rafting,

RE: .NET Web Forms in CF

2002-09-01 Thread Dave Watts
I'm working on a VB ASP.NET shopping cart using web forms. I wonder if anybody has any ideas on how to implement this architecture in CF. Any ideas on how whether or not it's a good idea? I think it would be more trouble than it's worth, but I'm not an expert on NET web forms. Dave

RE: how simultaneously pull data from an insert

2002-09-01 Thread Dave Watts
I'm building a tool that will track problems through out their lifecycle. People input data in the form fields, you hit submit and the fields are populated into the database. What I'm looking to retrieve is the auto generated number for that specific row that the data was just inserted

Re: Nth Record Subset

2002-09-01 Thread Jochem van Dieten
S. Isaac Dealey wrote: If you have some consecutive number use the MOD operator in your WHERE. This might work provided there's never a problem inserting a record with an autonumber field in at least MS SQL Server ( a failed insert still chews up a record number ), and have never deleted

Re: Nth Record Selection Set

2002-09-01 Thread Jochem van Dieten
Jesse Houwing wrote: In MySQL, PostgreSQL and such: SELECT * FROM table LIMIT startrow, numberofrows so the 15000th item en the 15 following it would be: SELECT * FROM table LIMIT 15000, 15 Deprecated syntax for PostgreSQL. Use LIMIT ... OFFSET ... instead. SELECT * FROM table LIMIT

Re: Flash Rich App Approach = Macromedia?

2002-09-01 Thread Sean A Corfield
On Saturday, August 31, 2002, at 02:25 , Benoit Hediard wrote: There was a very interesting article in InternetWeek on tuesday : Laszlo Rising: The Inside Story Of A Stealth Vendor's Rich App Plans (http://www.internetweek.com/story/INW20020827S0008). Yes, this was circulated internally. It's

Re: Auto form submission

2002-09-01 Thread Gyrus
- Original Message - From: Candace Cottrell [EMAIL PROTECTED] Is there a way a form can be submitted withoutthe user having to click a sumbit button? (automatically) --- I think you need to look in JavaScript: form.submit(); HTH, - Gyrus

Re: Nth Record Subset

2002-09-01 Thread Bud
On 8/30/02, Jim Gurfein penned: Hi List, All you gurus out there... I'm trying to find a way to select every nth record from a database that has 200,000 records. How would I go about setting up the SQL to select every 15th record ? Any and all help would be appreciated! Not sure how or if you

Re: Looping depending on CFIF Statement

2002-09-01 Thread Bud
On 8/29/02, Angel Stewart penned: I keep getting errors as though CF is totally ignoring the CFIF statement and still parsing the /CFLOOP tag. Here is some simple sample code: CFIF LoopYes EQ True cfloop index=count from=1 to=10 /CFIF cfloop index=theindex from=1 to=2

Re: CFC theory

2002-09-01 Thread Jeffry Houser
I almost skipped over this post because it was all quotes. ( I imagine that was because the list was bouncing stuff for a bit). At 08:04 PM 8/31/2002 -0700, you wrote: On Friday, August 30, 2002, at 10:35 , Jeffry Houser wrote: I think this is too good of a topic to pass up, and I

RE: Auto form submission

2002-09-01 Thread Joe Eugene
you can use an inline JavaScript to submit the form. script language=JavaScript document.formName.submit() /script this should fire after all the form variables if you want to auto submit. Joe Certified Advanced ColdFusion Developer [EMAIL PROTECTED] -Original Message- From:

RE: Flash Rich App Approach = Macromedia?

2002-09-01 Thread Joe Eugene
I am curious from all this FLASH/Flash MX talk.. Does Flash add any more USABILITY to existing critical applications...? than putting more overhead on the applications.. while it has to X no of things... Thoughts? Joe -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]]

Re: Flash Rich App Approach = Macromedia?

2002-09-01 Thread Sean A Corfield
On Sunday, September 1, 2002, at 08:57 , Joe Eugene wrote: Does Flash add any more USABILITY to existing critical applications...? Yes. The HTML-based web experience is not exactly ideal... Look at the scenario of booking a flight, for example. See how many pages you have to click through

Re: CFC theory

2002-09-01 Thread Sean A Corfield
On Sunday, September 1, 2002, at 08:27 , Jeffry Houser wrote: I almost skipped over this post because it was all quotes. ( I imagine that was because the list was bouncing stuff for a bit). Yeah, sorry about that. 3. Is the data created inside a component protected from outside forces?

CFC resources

2002-09-01 Thread Gyrus
Can anyone recommend some CFC resources? As in good books or articles on the web (apart from the obvious MM stuff)? I'm especially interested in which of the spate of new CFMX books covers CFC's best. Obviously I'd like to buy something that covers *all* of MX well, but not being from a computer

Re: CFC resources

2002-09-01 Thread Michael Dinowitz
http://www.techspedition.com/store/moreinfo.cfm?Product_ID=3 http://cfczone.org/ Can anyone recommend some CFC resources? As in good books or articles on the web (apart from the obvious MM stuff)? I'm especially interested in which of the spate of new CFMX books covers CFC's best.

Re: CFMX :: URLSessionFormat :: J2EE

2002-09-01 Thread Jesse Houwing
Bill Davies wrote: Has anyone on the list experienced a problem with the J2EE session ID appended by URLSessionFormat()? On the server in question (Win2k SP3, IIS 5) you end up with links that look like: myPage.cfm;JSESSIONID=8030949691025145133137?myVar=myVal which then throws a

RE: Flash Rich App Approach = Macromedia?

2002-09-01 Thread Stacy Young
Well the other thing is they're assuming that one developer is doing it all?? Architecture, coding and GUI design/actionscript? If so then a text IDE / Studio type approach may generate a little interest but in the grand scheme I'd say the larger projects typically have multiple players no? The

Re: Flash Rich App Approach = Macromedia?

2002-09-01 Thread Douglas Brown
Maragret, I felt the need to chime in on this with a question. I am thinking of designing an ecommerce app and would like the entire site to be done in flash. One of the things that concerns me is the indexing by search engines...If I go this way, would I be limiting myself with small search

RE: Nth Record Selection Set

2002-09-01 Thread Matthew Friedman
is there a limit function ins SQL Server 2000? -Original Message- From: Jesse Houwing [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 01, 2002 8:17 AM To: CF-Talk Subject: Re: Nth Record Selection Set Jim Gurfein wrote: Hi List, Sorry for sending this again, but the list was

Re: Flash Rich App Approach = Macromedia?

2002-09-01 Thread Jon Hall
Interesting list, but you omitted the two technologies that actually have a chance against Macromedia in the whole Rich Media game imo. Those being SVG, backed by the W3C and Adobe among others, and .Net with it's WinForms component being integrated into the CLR. SVG is easier to understand to me

Re: Evaluate???

2002-09-01 Thread Matthew Walker
If QueryName above is the actual name of the query (as opposed to a variable containing that name), you should be able to do this: cfset list = Evaluate(ValueList(QueryName.#Attributes.PrimaryKey#)) or on cf5+: cfset list = ValueList(QueryName[Attributes.PrimaryKey])

RE: Flash Rich App Approach = Macromedia?

2002-09-01 Thread Joe Eugene
Sean, Sounds like an Applet download the entire dataset to the user and have a static application with frames moving in and outwith changing params...? and the screen is never refreshed? so how is client/session state managed? Interesting.. wonder

RE: CFMX :: URLSessionFormat :: J2EE

2002-09-01 Thread Bill Davies
Say Jesse - what's a UDF? :) -Original Message- From: Jesse Houwing [mailto:[EMAIL PROTECTED]] Sent: 01 September 2002 18:55 To: CF-Talk Subject: Re: CFMX :: URLSessionFormat :: J2EE Bill Davies wrote: Has anyone on the list experienced a problem with the J2EE session ID appended by

RE: CFMX :: URLSessionFormat :: J2EE

2002-09-01 Thread Jeffry Houser
Short-hand for User Defined Function. At 10:07 PM 9/1/2002 +0100, you wrote: Say Jesse - what's a UDF? :) -Original Message- From: Jesse Houwing [mailto:[EMAIL PROTECTED]] Sent: 01 September 2002 18:55 To: CF-Talk Subject: Re: CFMX :: URLSessionFormat :: J2EE Bill Davies wrote:

Re: Nth Record Subset

2002-09-01 Thread S . Isaac Dealey
S. Isaac Dealey wrote: If you have some consecutive number use the MOD operator in your WHERE. This might work provided there's never a problem inserting a record with an autonumber field in at least MS SQL Server ( a failed insert still chews up a record number ), and have never deleted

Re: Nth Record Selection Set

2002-09-01 Thread Jochem van Dieten
Matthew Friedman wrote: is there a limit function ins SQL Server 2000? No/yes. Look up TOP, but in order to create an offset you need to use it twice. Pseudo SQL: SELECT TOP 15 * FROM ( SELECT TOP 15015 * FROM table1 ORDER BY id DESC ) table2 ORDER BY id ASC

Flas MX CF 4.5.2

2002-09-01 Thread Rick Faircloth
I would like to tinker with Flash MX and work on some of the sample apps...the question is, could I install it on my development box with CF 4.5.2, or would I have to change to CF MX? I'm in the middle of projects and can't change CF versions now... Rick

TEST

2002-09-01 Thread Frank Mamone
TEST __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives:

list to array, now to another array

2002-09-01 Thread Tony Weeg
1 7|5372|0|Credit Card|1250 2 8|5108743|2831|Auto Loan|32967 3 9|74|370|Installment|2839 4 10|56675|238|Credit Card|1500 5 11|87115439|1952|Auto Loan|9938 6 12|917|184578|Mortgage|189255 7 13|601100248726|0|Credit Card|1000 8

Re: Nth Record Selection Set

2002-09-01 Thread Jim Gurfein
Your second selection concept was correct... eg :every third or 15th or 20th record At 10:22 AM 9/1/2002 -0400, you wrote: Jim Gurfein wrote: Hi List, Sorry for sending this again, but the list was having problems All you gurus out there... I'm trying to find a way to select

Re: Nth Record Selection Set

2002-09-01 Thread Jim Gurfein
These functions don't appear in MSSQL7.0... the mod function is represented by '%' in the select as a function... so far, I'm not a real lot closer to answer this problem. Anyone know of a way to create some sort of on the fly Identity number (rowcount in cf) that would all this usage? At

Uniquely identifing a structure.

2002-09-01 Thread James Sleeman
Hi all, I need to get a simple string value that will uniquely identify a given structure, currently what I am using is this... CFWDDX ACTION=CFML2WDDX INPUT=#AStructure# OUTPUT=AWddx CFSET aKey = Hash(AWddx) which produces exactly what I want, but my problem is that this happens several

RE: Uniquely identifing a structure.

2002-09-01 Thread Matthew Walker
May be missing what you're trying to do, but how about generating a uuid and then having another structure linking uuids to structures. cfset aKey = CreateUUID() cfset myStructs[aKey] = AStructure You are of course only storing a reference to the struct, not the struct itself. Matt.

RE: Uniquely identifing a structure.

2002-09-01 Thread Pete Freitag
You could add a key to the structure that contains a unique ID... cfset aStructure.uuid = CreateUUID() CFWDDX ACTION=CFML2WDDX INPUT=#AStructure# OUTPUT=AWddx _ Pete Freitag CTO, CFDEV.COM ColdFusion Developer Resources http://www.cfdev.com/

RE: Uniquely identifing a structure.

2002-09-01 Thread Matt Liotta
If you are using CFMX you can get the HashCode of the underlying HashMap. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ V: 415-577-8070 F: 415-341-8906 P: [EMAIL PROTECTED] -Original Message- From: James Sleeman [mailto:[EMAIL PROTECTED]] Sent:

Re: list to array, now to another array

2002-09-01 Thread Brook Davies
I don't know if this is what you mean, but you could convert each item in your original array to an array itself, so you would have an array of arrays. If your FullReturn Array looks like the one below, you could try something like: cfloop from=1 to=#arraylen(FullReturn)# index=ArrayPos

RE: list to array, now to another array

2002-09-01 Thread Tony Weeg
brook, let me try that...im also playing with putting it into a structure called accounts, and from there access the data from the structure although structures are a bit tricky, this is my first time down structure rowso we will see thanks. tw -Original Message- From:

RE: list to array, now to another array

2002-09-01 Thread Matthew Walker
You want an array of structs. cfloop from=1 to=#arrayLen(FullReturn)# index=i cfset tempStruct = structNew() cfset tempStruct.id = listGetAt(FullReturn[i], 1, |) cfset tempStruct.something = listGetAt(FullReturn[i], 2, |) cfset tempStruct.somethingelse =

RE: list to array, now to another array

2002-09-01 Thread Tony Weeg
genious LADIES and GENTS! the man is a genious. thank youMatt :) tw -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 01, 2002 9:41 PM To: CF-Talk Subject: RE: list to array, now to another array You want an array of structs. cfloop

Re: Nth Record Selection Set

2002-09-01 Thread Jon Hall
Yeah, rowcount is the issue. SQL Server has no rowcount functionality unfortunately. A temporary table is probably the most used way around the problem. http://www.faqs.org/faqs/databases/sybase-faq/part14/ About midway down on the page, it tell you how do get a rowcount. This is for Sybase, but

Re: Uniquely identifing a structure.

2002-09-01 Thread Jon Hall
How? -- jon mailto:[EMAIL PROTECTED] Sunday, September 1, 2002, 9:03:38 PM, you wrote: ML If you are using CFMX you can get the HashCode of the underlying ML HashMap. ML Matt Liotta ML President CEO ML Montara Software, Inc. ML http://www.montarasoftware.com/ ML V: 415-577-8070 ML F:

RE: list to array, now to another array

2002-09-01 Thread Matthew Walker
the man is a genious. thank youMatt :) I wish I was, but I do love structures ;-) __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives:

Re: Uniquely identifing a structure.

2002-09-01 Thread James Sleeman
- Original Message - From: Matthew Walker [EMAIL PROTECTED] May be missing what you're trying to do, but how about generating a uuid and then having another structure linking uuids to structures. cfset aKey = CreateUUID() cfset myStructs[aKey] = AStructure Yea, no :-) Perhaps I

RE: Nth Record Selection Set

2002-09-01 Thread Joe Eugene
I can see using 2 options for doing this.. 1. ColdFusion Way. cfquery name=whatever select UniqueIDField from TableName order by UniqueIDField /cfquery cfset aRowids=arrayNew(1) cfloop query=whatever cfif NOT whatever.currentRow mod 15 cfset

RE: Query resuts into structure

2002-09-01 Thread Joe Eugene
If you just want add ONE Product id into a structure? cfscript MyStruct=StructNew(); MyStruct.ProductID=QueryName[ColumnName][1]; ///[1] is the row returned from the query /cfscript cfoutput #MyStruct.ProductID# /cfoutput will give you the results... now if you want add multiple Product ids

RE: Query resuts into structure

2002-09-01 Thread Joe Eugene
opps i forgot to put this option.. without an array in the structure cfscript MyStruct=StructNew(); MyStruct.ProductID=valueList(QueryName.ProductID,,); /cfscript -Original Message- From: Joe Eugene [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 01, 2002 11:25 PM To: CF-Talk

RE: Flash MX CF 4.5.2

2002-09-01 Thread Dave Watts
I would like to tinker with Flash MX and work on some of the sample apps...the question is, could I install it on my development box with CF 4.5.2, or would I have to change to CF MX? As long as you're not interested in trying out Flash Remoting, you can use Flash MX with CF 5 or earlier

Re: Flas MX CF 4.5.2

2002-09-01 Thread Sean A Corfield
On Sunday, September 1, 2002, at 04:04 , Rick Faircloth wrote: I would like to tinker with Flash MX and work on some of the sample apps...the question is, could I install it on my development box with CF 4.5.2, or would I have to change to CF MX? You certainly install it and develop

Re: Flash Rich App Approach = Macromedia?

2002-09-01 Thread Sean A Corfield
On Sunday, September 1, 2002, at 11:17 , Douglas Brown wrote: I felt the need to chime in on this with a question. I am thinking of designing an ecommerce app and would like the entire site to be done in flash. One of the things that concerns me is the indexing by search engines...If I go

Re: Flash Rich App Approach = Macromedia?

2002-09-01 Thread Sean A Corfield
On Sunday, September 1, 2002, at 02:14 , Joe Eugene wrote: Sounds like an Applet Perhaps, although Applet UIs tend to be larger downloads - and Java support is not actually as solid as Flash support in browsers. download the entire dataset to the user and have a static

  1   2   >