RE: How XML benefits ColdFusion developers

2002-02-04 Thread John McCosker
I would just use ASP instead of CF. Then you can just make XSL files that will do the same thing, and it is really designed for that. Why ASP over CF to do this, I don't understand! I would have thought the power of XSL was client side so I would have thought, JavaScript instead of VBScript.

CFMail Crashing the server....

2002-02-04 Thread Axiomatique (Vincent)
Hello folks, I had seen a thread way back about an empty message (0k) in the cfusion/mail/spoll directory getting CFserver to 100% CPU. Well I experienced exactly the same thing today. Recycled the service /with TaskMonitor on and in a split second that CF Application Server started up

RE: asp dns managment object

2002-02-04 Thread Ian Tait
Go for it. Ian -Original Message- From: Bill Davidson [mailto:[EMAIL PROTECTED]] Sent: 03 February 2002 22:32 To: CF-Talk Subject: Re: asp dns managment object I have written a pretty feature rich DNS manager in CF (lots of built intelligence - error checking and resolution, etc..).

RE: asp dns managment object

2002-02-04 Thread Darren Daniel
I'm feeling that too. Darren -Original Message- From: Ian Tait [mailto:[EMAIL PROTECTED]] Sent: 04 February 2002 11:53 To: CF-Talk Subject: RE: asp dns managment object Go for it. Ian -Original Message- From: Bill Davidson [mailto:[EMAIL PROTECTED]] Sent: 03 February 2002

RE: asp dns managment object

2002-02-04 Thread Andrew Scott
I would say that there would be enough interest, but in what way are you thinking of DNS management are we talking s set of custom tags that can be used internal to an application or are we talking so that we interact through the web? -Original Message- From: Bill Davidson [mailto:[EMAIL

SELECT MAX Problem.

2002-02-04 Thread Martin Sutton
Dear all, I am having trouble with the following query: CFQUERY name=GetLastRecord datasource=#application.datasrc# SELECT MAX(#ListGetAt(#auditQueryName#.Columnlist, 1)#) AS key FROM #auditQueryTable# /CFQUERY CF gives me an error: Invalid expression format. If I surround it

Help! Building a dynamic JS array with over 1100 elements

2002-02-04 Thread Pete Ruckelshaus
OK, here's the deal. I'm implementing a JavaScript user lookup (http://users.andassoc.com/gibbs/beerology.html is a static mockup and the real site is at http://www.beerology.com/ars/) and I can't think of the best way to get started. The current implementation of just a select box has loading

Printing a dynamic page ... doesnt work how to fix?

2002-02-04 Thread Mike Kear
I have a page that contains a buyer's guide and is created dynamically. When users print it from Netscape, all they get is a page saying data is missing. Does anyone know how can I fix this? Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks

Re: Community Manager for ColdFusion Position

2002-02-04 Thread Pete Ruckelshaus
Any chance this position would allow the successful applicant to telecommute full-time from, say, suburban Philadelphia, PA? :-) - Original Message - From: Matt Brown, Community Manager [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, February 01, 2002 5:01 PM Subject: Re:

RE: Community Manager for ColdFusion Position

2002-02-04 Thread Neil Clark
Or say from London, England? __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ:

Re: SELECT MAX Problem.

2002-02-04 Thread David Schmidt
Try moving your 3rd # sign like this... CFQUERY name=GetLastRecord datasource=#application.datasrc# SELECT MAX(#ListGetAt(#auditQueryName.Columnlist#, 1)#) AS key FROM #auditQueryTable# /CFQUERY - Original Message - From: Martin Sutton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED]

RE: SELECT MAX Problem.

2002-02-04 Thread Pascal Peters
If auditQueryName contains the query name and not the query: cfset myQuery = Evaluate(auditQueryName) CFQUERY name=GetLastRecord datasource=#application.datasrc# SELECT MAX(#ListGetAt(myQuery.Columnlist, 1)#) AS key FROM #auditQueryTable# /CFQUERY -Original Message- From:

RE: CFMail Crashing the server....

2002-02-04 Thread Carlisle, Eric
At times, I've used CDONTS to evade the problem alltogether. I'd like to use CFMAIL, but issues like this cause me to steer away. EC -Original Message- From: Axiomatique (Vincent) [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 5:54 AM To: CF-Talk Subject: CFMail

Re: Printing a dynamic page ... doesnt work how to fix?

2002-02-04 Thread Pete Ruckelshaus
Is this page the result of a Form POST method? Pete - Original Message - From: Mike Kear [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, February 04, 2002 8:18 AM Subject: Printing a dynamic page ... doesnt work how to fix? I have a page that contains a buyer's guide

crystal reports vs... ?

2002-02-04 Thread Michael Vinson
Hi Listers, I'm peering into my crystal snowball and I see dozens of complex reports in my near future. These reports need to be generated from dynamic (server-side) databases whipped up to the user in an editable format (rtf/doc). I have used an open-source Perl script (now an open source kit

RE: SELECT MAX Problem.

2002-02-04 Thread Greg
It sounds like you might want listlen() of that columnlist, instead of listgetat()? But would it work to just select the max(auditquerytable_id) from auditquerytable? I don't think I understand the situation completely. -Original Message- From: Martin Sutton [mailto:[EMAIL PROTECTED]]

Cftry/cfcatch

2002-02-04 Thread Kris Pilles
I need to put iun place a really simple error management system. I was wondering what the drawbacks, if any were of putting cftry/catch statements in an application.cfm were? Any other ides on how to easily allow 1 generic error page for our app would be appreciated.

RE: Cftry/cfcatch

2002-02-04 Thread Kola Oyedeji
cferror is exactly what you are looking for! Kola Oyedeji Web developer Macromedia Certified Advanced ColdFusion 5 Developer ekeda ltd http://www.ekeda.co.uk (+44)020-8429-7300 -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: 04 February 2002 14:52 To: CF-Talk

RE: Cftry/cfcatch

2002-02-04 Thread Kola Oyedeji
To add to that, place it in you application.cfm and give it the name of the template you want displayed if there is an error as one of the attributes! HTH Kola Oyedeji Web developer Macromedia Certified Advanced ColdFusion 5 Developer ekeda ltd http://www.ekeda.co.uk (+44)020-8429-7300

CF Automated Tasks~!

2002-02-04 Thread Kris Pilles
I've used automated tass before and had no trouble. But I'm on a new server now and I have my events scheduled to execute and they simply don't. When I manually execute them form wihtin the administrator they work fine, they just don't exexcute automatically like I want them to Any ideas on

RE: CF Automated Tasks~!

2002-02-04 Thread mark kecko
I just fought through this!! Check the NT permissions on your folder on your new server, replace them to allow CF to execute the page. -mark -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 10:32 AM To: CF-Talk Subject: CF Automated

mySQL Primary Keys.

2002-02-04 Thread Martin Sutton
Dear all, Firstly thanks for the replies I received earlier. I tried what was suggested and it has worked up to a point. The problem I have now is that I need to assign the primary key field name to a variable. Is it possible to do this without knowing the name of the primary key? i.e SELECT

RE: MSSQL w/ OLEDB or ODBC

2002-02-04 Thread Alistair Davidson
Hi, At my last place we swapped all SQL drivers over from ODBC to OLEDB. We didn't really get much of a performance difference, but there was a noticeable increase in stability. I'd say it's definitely worth doing. Just be warned, we did find some niggling syntax differences in some obscure

Re: Help! Building a dynamic JS array with over 1100 elements

2002-02-04 Thread Douglas Brown
Is this what you need? Query1 Well just use the recordcount for your ending loop value IE: from=1 to =#myQuery.recordCount#. Not sure about the index of the array, are you saying you want to use a non numeric value for the index? I would think that this would cause problems in sorting the

RE: CF Automated Tasks~!

2002-02-04 Thread Kris Pilles
I set it to full control and enabled logging so hopefully this will give me an idea of whats happening. Which Folder were you talking about. The one where the file resides of the cfadmin folders? -Original Message- From: mark kecko [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04,

RE: CF Automated Tasks~!

2002-02-04 Thread mark kecko
The folder where the file to be executed resides. -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 10:56 AM To: CF-Talk Subject: RE: CF Automated Tasks~! I set it to full control and enabled logging so hopefully this will give me an idea

Graphics Custom tag

2002-02-04 Thread Graham Lewis
I am stuck with CF 4.5 so do not have the luxury of CFGRAPH that comes with v5. Is there a free custom tag around that will allow me to do simple graphs? Graham Graham Lewis Centre for Academic Practice University of Warwick CV4 7AL Tel: 024 765 73109 Mobile: 07733450022

OT: crystal reports vs... ?

2002-02-04 Thread Costas Piliotis
Good luck... I've built a report generator for us, and it's been a work in progress for the last year :) As far as I know, crystal 8.5 has its own scripting language now that *gasp* looks just like ASP. Working with 8 however, I've come up with a way of using stored procedures for my dynamic

Re: Community Manager for ColdFusion Position

2002-02-04 Thread Matt Brown, Community Manager
The question of whether the CM can commute from a remote site is no. The management is anxious to have more CF knowledge in house at the SF office. That was the first question I asked as well. _ Matt Brown Community Manager -

Re: Graphics Custom tag

2002-02-04 Thread Bryan Stevenson
If you're doing bar graphs you can do them easily without a tag. The basic idea is to have a transparent 1x1 pixel gif. Do your calculations on your data.then dynamically set the height of the 1 pixel gif (and set different bgcolors on the td's for different bars) and manually set the

Re: Graphics Custom tag

2002-02-04 Thread Michael Smith
You can write your own bar graphs using CF, image tags and a 1x1 pixel graphic. Just size the image based on the length of bar you need. I think there is some code on WebMonkey for this. If you can afford a paid graphing solution and need more complex graphing types with more control then our

Allaire Forums

2002-02-04 Thread Nelson Winters
Does anyone know where I can get a copy of the old Allaire Forums? I know that at one point they made it an open source project at www.forumspot.org, but apparently that site is no longer live. Thanks, Nelson __ Why Share?

Re: Graphics Custom tag

2002-02-04 Thread Graham Lewis
Yes it occured to me and its a good fallback but if there is a tag that makes it even easier Graham Graham Lewis Centre for Academic Practice University of Warwick CV4 7AL Tel: 024 765 73109 Mobile: 07733450022 [EMAIL PROTECTED] 02/04/02 05:01pm If you're doing bar graphs you can do

Header error (resend)

2002-02-04 Thread Dave Clay
Can any one tell me why I get this messege. I cannot see abnormal coding or JS to produce this. Any help would be appreciated. Thank you Dave Clay trusjoist.com HTTP/1.1 100 Continue Server: Microsoft-IIS/5.0 Date: Mon, 04 Feb 2002 17:17:45 GMT HTTP/1.1 500 Internal Server Error Server:

Re: Community Manager for ColdFusion Position

2002-02-04 Thread Michael Dinowitz
This is the main reason I wouln't get the job. I've contemplated moving to SF, I've talked it over with Judith and the bottom line is that we just don't want to move. I'd do a week there a month or every other week, but I don't think it'll go. It's got me a little down. I need to have more

Re: CFMail Crashing the server....

2002-02-04 Thread Chris Norloff
A known bug in CF 4.5. Not fixed until ver 5. Chris Norloff -- Original Message -- from: Axiomatique (Vincent) [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Mon, 4 Feb 2002 11:53:44 +0100 Hello folks, I had seen a thread way back about an

Re: asp dns managment object

2002-02-04 Thread Bill Davidson
A bit of both. It is written to be an application, but I kept custom tags in mind.. Behind the scenes it is largely custom tag based, and if I release it, I'll push that even further. I've gotten a pretty good response. I'll let everyone know when I have a beta version. Thanks all, -Bill

Re: Community Manager for ColdFusion Position

2002-02-04 Thread Michael Dinowitz
Sorry, the post below was sent with the assumption that it was to CF-Community, where this has been discussed more in depth. At 12:16 PM 2/4/02, you wrote: This is the main reason I wouln't get the job. I've contemplated moving to SF, I've talked it over with Judith and the bottom line is

Re: Community Manager for ColdFusion Position

2002-02-04 Thread Jeffry Houser
We feel for your Michael. I'm sure I'm not the only one who would love to see you in that position. As I believe was mentioned on the community list, who is more community-oriented than you? I'm slightly amused I did not see the job post on the cf-jobs list, though (It could have been

RE:(OT) Community Manager for ColdFusion Position

2002-02-04 Thread Kola Oyedeji
Surely they can relocate their offices closer to you right? ;-) Kola Oyedeji Web developer Macromedia Certified Advanced ColdFusion 5 Developer ekeda ltd http://www.ekeda.co.uk (+44)020-8429-7300 -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: 04 February

Any one here work on Mercury Marine site?

2002-02-04 Thread Phillip Broussard
There is an application written for Mercury Marine so that certain people can log in and download images for print and web. I think it's called MercNet. The company I work for wants to do something like this too so I wanted to get some ideas on what to look out for and get some general advice.

RE: asp dns managment object

2002-02-04 Thread Lee Fuller
Good deal... Yes, do keep the tag portions in mind, since that would be our best shot at using it as part of our overall tool set. We need the ability to customize the interface, so a tag is the best way to go. (For us at least. ;) Keep us all posted! Lee Fuller Chief Technical Officer

Re: Community Manager for ColdFusion Position

2002-02-04 Thread Michael Dinowitz
Matt asked if he could post it to CF-Talk and I agreed. Its of such great importance to us that it should get to the largest concentration of CF people around. If it wasn't posted to the CF-Jobs list then either Matt will send it or I'll forward it. On the whole, most of the people on the

Re: Graphics Custom tag

2002-02-04 Thread Deanna Schneider
I wrote a sort of kludgy scatter graph tag based on dhtml (and all its downfalls). Let me know if you want it and I'll dig it up. -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] __ Why Share? Dedicated

RE: Graphics Custom tag

2002-02-04 Thread Joseph DeVore
Check out CFX_IMAGE; you will be very happy with it once you understand it. HTH, Joseph DeVore VeloxWeb Technologies -Original Message- From: Graham Lewis [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 9:12 AM To: CF-Talk Subject: Re: Graphics Custom tag Yes it occured

Re: Community Manager for ColdFusion Position

2002-02-04 Thread SimplyKool26
I think you're a resident of Maryland right now, no? Btw, I used to live in the DC metro area and moved to Bay Area 2 years ago. It's been great for me. I love living around this life but I really miss my family back home though. Bay Area is a great place to live and the Cold Fusion

cfselect and required=yes

2002-02-04 Thread Shawn Regan
I can never get the required attribute to work on cfselect is there a trick? Code: cfselect name=title required=Yes message=A title is required. option/option option value=Service Manager Service Manager/option option value=Parts ManagerParts

RE: cfselect and required=yes

2002-02-04 Thread Dave Watts
I can never get the required attribute to work on cfselect is there a trick? Unless you create a multi-select box, any HTML SELECT, including one generated with CFSELECT, will always have an item selected. The REQUIRED attribute only affects multi-select boxes. Dave Watts, CTO, Fig Leaf

RE: cfselect and required=yes

2002-02-04 Thread Tony Gruen
select inputs are only validated by CF on the server side. These and textboxes will need to be done client side with something like javasc ript. T -Original Message- From: Shawn Regan [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 10:54 AM To: CF-Talk Subject: cfselect and

Re: Inserting new fields into database...

2002-02-04 Thread phumes1
I keep getting this error when I try to insert new fields into my database. Error Diagnostic Information ODBC Error Code = 23000 (Integrity constraint violation) [Microsoft][ODBC Microsoft Access Driver] The changes you requested to the table were not successful because they would create

RE: cfselect and required=yes

2002-02-04 Thread Christopher Olive
actually, using CFFORM and CFWHATEVERFORMELEMENT will generate the JS for you. christopher olive, cto, vp of web development atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Tony Gruen [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002

RE: Inserting new fields into database...

2002-02-04 Thread Christopher Olive
what's the primary key in the table? sounds like you're inserting a row with a duplicate primary key value (which is, of course, what the error message says). christopher olive, cto, vp of web development atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original

Setting Query results as a Variable

2002-02-04 Thread Jim Vosika
I am querying my Database and getting back multiple results, as you with any query. I would like to put those results into a Variable to be used in a CFFILE function like: CFFILE ACTION=WRITE FILE=file.html OUTPUT=#MyQueryVariable# Here is my query if it matters: CFQUERY DATASOURCE=createhtml

RE: Inserting new fields into database...

2002-02-04 Thread Lee Fuller
Means that a piece of data you're trying ton add to the database is the same as another piece of data that already exists in the database AND that is in a field that has it's index setting to Yes (No Duplicates). HTH Lee Fuller Chief Technical Officer PrimeDNA / AAA Web Hosting Corporations

RE: Setting Query results as a Variable

2002-02-04 Thread Ben Forta
Use CFSAVECONTENT to grab the output and save it in a variable, or if you need a single column and want it as a list use ValueList() or QuotedValueList(). --- Ben -Original Message- From: Jim Vosika [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 2:18 PM To: CF-Talk

RE: Inserting new fields into database...

2002-02-04 Thread Tyler M. Fitch
Hi, Somewhere in your Access table definition you've defined a column, and it might not be the primary key, as requiring unique values. So you're going to need to check your table columns in Access and see which columns have the indexed value set to yes - no duplicates and change it to yes -

RE: Inserting new fields into database...

2002-02-04 Thread phumes1
Profile_ID is the primary key and the DataType is AutoNumber NewValues = increment Indexed = Yes (No duplicates) Do I need to change the database settings on the primary key? At 02:14 PM 2/4/2002 -0500, you wrote: what's the primary key in the table? sounds like you're inserting a row with a

Re: Setting Query results as a Variable

2002-02-04 Thread Paul Giesenhagen
Ok so that was much easier than how I went around it .. :) Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder Use CFSAVECONTENT to grab the output and save it in a variable, or if you need a single column and want it as a list use ValueList() or

Using CFTRY - CFCATCH to rollback database tranaction

2002-02-04 Thread mark kecko
Is there a way to use CFTRY - CFCATCH to rollback all database tranactions within given block? In otherwords, If I'm running 4 update queries and the first three are ok but the last one fails I want to roll them all back. Is there a better way to do this than usign CFTRY - CFCATCH? Mark Kecko

RE: Inserting new fields into database...

2002-02-04 Thread Ken Wilson
Are you trying to insert a value into the Profile_ID field? -Original Message- From: phumes1 [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 2:28 PM To: CF-Talk Subject: RE: Inserting new fields into database... Profile_ID is the primary key and the DataType is AutoNumber

Microsoft and Macromedia

2002-02-04 Thread Costas Piliotis
http://forum.fuckedcompany.com/phpcomments/index.php?newsid=82133page=1par entid=0crapfilter=1 Anyone know if there's any truth to this? (Pardon the language in the link - What else could I do?) __ Get Your Own Dedicated

Re: Microsoft and Macromedia

2002-02-04 Thread Howie Hamlin
OMG - not this again! It's a rumor...please have a look at the cf-talk and cf-community archives. Howie - Original Message - From: Costas Piliotis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, February 04, 2002 2:56 PM Subject: Microsoft and Macromedia

RE: Microsoft and Macromedia

2002-02-04 Thread Haggerty, Michael A.
No. -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 2:56 PM To: CF-Talk Subject: Microsoft and Macromedia http://forum.fuckedcompany.com/phpcomments/index.php?newsid=82133page =1par entid=0crapfilter=1 Anyone know if there's any

RE: Using CFTRY - CFCATCH to rollback database tranaction

2002-02-04 Thread Haggerty, Michael A.
Mark; Put everything in a CFTRANSACTION type=serializeable block. Should one fail, they are all rolled back. Mike -Original Message- From: mark kecko [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 2:41 PM To: CF-Talk Subject: Using CFTRY - CFCATCH to rollback database

RE: Microsoft and Macromedia

2002-02-04 Thread Christian Abad
Run Costas, Run!!! -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 2:56 PM To: CF-Talk Subject: Microsoft and Macromedia http://forum.fuckedcompany.com/phpcomments/index.php?newsid=82133page=1par entid=0crapfilter=1 Anyone know if

RE: Microsoft and Macromedia

2002-02-04 Thread Costas Piliotis
Sorry folks... Please don't flame me over this... Didn't know this was in cf-talk archives... Just had a customer come across this and had to go to the sources... Thanks! -Original Message- From: Christian Abad [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 12:03 PM To:

RE: Microsoft and Macromedia

2002-02-04 Thread Dan Phillips
I'm running down to the storm cellar now if anyone wants to join me. lol -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 2:59 PM To: CF-Talk Subject: Re: Microsoft and Macromedia OMG - not this again! It's a rumor...please have a look

RE: Using CFTRY - CFCATCH to rollback database tranaction

2002-02-04 Thread Tyler M. Fitch
Mark, Depending on what database you're using cftransaction should do exactly what you want. cftransaction cfquery1 cfquery2 cfquery3 cfquery4 /cftransaction If anything in all those queries fails they all get rolled back to their original state. A

RE: Microsoft and Macromedia

2002-02-04 Thread Mark A. Kruger - CFG
Not again. (Mark puts on his sack cloth and ashes) Mark A. Kruger, MCSE, CFG www.cfwebtools.com ..no more brochures! -Original Message- From: Christian Abad [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 12:03 PM To: CF-Talk Subject: RE: Microsoft and Macromedia Run

RE: Microsoft and Macromedia

2002-02-04 Thread John McCosker
Chill, what could you do if it where true, but evolve. Philosophical I know, but A FACT! j .. .. -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 7:56 PM To: CF-Talk Subject: Microsoft and Macromedia

Re: Microsoft and Macromedia

2002-02-04 Thread Jim Priest
Argh! You could: a. read the archives and realize this was just beat to death a week ago... b. sign up and ask about it in cf_community in the first place since there is absolutely no technical content whatsoever in your post... Now I gotta go edit my mail filters once again! :) jim On

Re: Allaire Forums

2002-02-04 Thread Jochem van Dieten
Nelson Winters wrote: Does anyone know where I can get a copy of the old Allaire Forums? I know that at one point they made it an open source project at www.forumspot.org, but apparently that site is no longer live. http://spike.oli.tudelft.nl/forumspot/ Jochem

Insert a list into a table - help!!!

2002-02-04 Thread Thanh Nguyen
I have a list with at least 3 items. And I want to insert it into table. right now, I'm looping through the list to insert them into db, but this is like writing multiple cfquery's. and what happens if my list has 20 items. cfloop index=index list=#mylist# cfquery insert

RE: Insert a list into a table - help!!!

2002-02-04 Thread John McCosker
cfquery cfloop index=index list=#mylist# insert into my_table (id, itemName) values (#ID#,'#index#' ) /cfloop /cfquery J .. .. -Original Message- From: Thanh Nguyen [mailto:[EMAIL PROTECTED]]

RE: Insert a list into a table - help!!!

2002-02-04 Thread Garza, Jeff
What database are you using? Jeff Garza Lead Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Thanh Nguyen [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 1:20 PM To: CF-Talk Subject: Insert a

RE: Microsoft and Macromedia

2002-02-04 Thread Cantrell, Adam
Summation of replies to this from last week: a. This is off topic, take it to cf-community. b. This is a rumor that was dispelled years ago, macromedia says so. c. You are a negative person for even asking! Why are you even spreading this rumor you piece of trash? You don't even belong in this

Client Variable Mix Up

2002-02-04 Thread Neil H.
For some reason I have an intranet site that everyone connects via their own IP address (no proxy). During the course of the day peoples sessions will be mixed up. Usernames which are found via client variables are linked to the wrong user. I originally had it as session variables, changed

Outputting issue

2002-02-04 Thread Paul Giesenhagen
Ok, I have a pretty basic question, but haven't used it much in the past so I am needing alittle help. I have a query: cfquery datasource=datasource name=getitems Select header,type,id,name from items /cfquery Each item coming from the above query has a header value, and I want to

HTML in Forms throwing page off

2002-02-04 Thread Jim Vosika
I'm just handling cosmetic problems on my page I have a form that I need to enter HTML code into but it throws my page off. Because I usually start by entering some /TD's which poses a problem. Is there some sort of tag I can wrap around the value so it so it doesn't do that?

Scheduled event Problems.....

2002-02-04 Thread Kris Pilles
Hres the error message I am receiving in my log file: 2002-02-04 15:10:11 Error 1256 Error message for task: 'Send ' is 'An error occurred while evaluating the expression: LOGMESSAGE = Status code for task: ' #Attributes.TASK# ' is ' #cfhttp.statuscode# '

RE: Outputting issue

2002-02-04 Thread Garza, Jeff
Try using the group attribute in your CFOUTPUT. CFOUTPUT query=getitems group=header #Header# CFOUTPUT #Type# -- #id# -- #Name# /CFOUTPUT /CFOUTPUT You should also use an order by clause in your select statement... Jeff Garza Lead Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL

Re: Outputting issue - RE-DO

2002-02-04 Thread Paul Giesenhagen
Sorry, my original post didn't make my output very clear Ok, I have a pretty basic question, but haven't used it much in the past so I am needing alittle help. I have a query: cfquery datasource=datasource name=getitems Select header,type,id,name from items /cfquery Each item coming

OT: How many in here bother to resell shared webspace?

2002-02-04 Thread Jeff Fongemie
Monday, February 04, 2002, 3:33:03 PM Hello cf-talk, Just wondering how many in here bother to resell webspace. By this I mean getting a large hosting plan at some host, then reselling the space to your clients. Typical reselling plan that many webhosts seem to push. If you do, does

Re: HTML in Forms throwing page off

2002-02-04 Thread Paul Giesenhagen
Try wrapping the output in #htmleditformat(form.content)# See if that works for ya. Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder - Original Message - From: Jim Vosika [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, February 04,

Re: Outputting issue

2002-02-04 Thread Paul Giesenhagen
What if I cannot do an OUTPUT query=getitems (already inside of an output) . - Original Message - From: Garza, Jeff [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, February 04, 2002 2:35 PM Subject: RE: Outputting issue Try using the group attribute in your CFOUTPUT.

Re: Inserting new fields into database...

2002-02-04 Thread Alex
post your code. also do you really mean insert new fields? or do you mean insert data into existing fields? On Mon, 4 Feb 2002, phumes1 wrote: I keep getting this error when I try to insert new fields into my databas e. Error Diagnostic Information ODBC Error Code = 23000 (Integrity

Re: OT: How many in here bother to resell shared webspace?

2002-02-04 Thread Matt Robertson
I did, now I don't. Never going back again: Their problems become your pr oblems. I found I do much better when I host my design clients only. I wr ote all of the code, so I know it works (or at least know where to fix it ; D) and my hosting revenue from existing clients now roughly equals my

RE: Client Variable Mix Up

2002-02-04 Thread Bryan Love
It could be many different things. Developing apps with client variables can be very tricky. Here are some things to keep in mind. Maybe one of them will point you in the right direction: - When using a DB to store client vars they are kept in a table called CDATA - Unless you say

Re: Client Variable Mix Up

2002-02-04 Thread Neil H.
How can I clear client variables. I don't think it clear from what I have seen. For session I used structdelete. Any ideas? Thanks, Neil - Original Message - From: Bryan Love [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, February 04, 2002 4:10 PM Subject: RE: Client

RE: Outputting issue

2002-02-04 Thread Garza, Jeff
Is the data in the second query related to the first? Or is it completely disjointed from the first query? If it's unrelated, you could build the HTML outside the first CFOUTPUT block and dump it to a variable for later. If your data is related to the original query, you'll have to use nested

RE: Microsoft and Macromedia

2002-02-04 Thread Costas Piliotis
Look in the archives and see how much I contribute to this list. Search for my name and see for yourself. That entitles me to ask. This is one of the first times I've actually asked a question in this forum. I really hope you're not symbolic of the cf-community at large. This was a customer

disappearing session variables

2002-02-04 Thread c talk
Hi all I'm using IE 5 and Nestcape 4.72 to develop a site for a client. I sometimes experience this error: Error resolving parameter BSESSION.PRODUCT_LINE/BPPThe session variable PRODUCT_LINE does not exist. This session.variable is defined and called on the site's home page. It's called

Re: Client Variable Mix Up

2002-02-04 Thread Kreig Zimmerman
cfscript // Remove all client variables variables.ThoseDangClients=GetClientVariablesList(); for(i=1;i LTE ListLen(variables.ThoseDangClients);i=i+1) { DeleteClientVariable(ListGetAt(variables.ThoseDangClients,i)); } /cfscript - Original Message - From: Neil H. [EMAIL

RE: OT: How many in here bother to resell shared webspace?

2002-02-04 Thread Mark A. Kruger - CFG
Ditto - We host managed code only - meaning we wrote or QAed the code on the box. No Access sites and no brochure sites. That way we can charge what it's actually worth to us (200 to 300 a site) rather than try to make it up in volume. We also don't advertise our hosting service because we

Re: Client Variable Mix Up

2002-02-04 Thread Neil H.
THANKS! Neil - Original Message - From: Kreig Zimmerman [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, February 04, 2002 4:18 PM Subject: Re: Client Variable Mix Up cfscript // Remove all client variables variables.ThoseDangClients=GetClientVariablesList();

Custom Tags

2002-02-04 Thread Paul Giesenhagen
I have a question -- looking for a better way of doing things: Currently, I am using custom tags to run queries, and take the various bits of information and re-package it into queries, THEN packaging the results up into a WDDX Packet. Outside of the Custom Tag I am unpackaging the WDDX Packet

RE: Insert a list into a table - help!!!

2002-02-04 Thread Thanh Nguyen
MSSQL -Original Message- From: Garza, Jeff [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 12:24 PM To: CF-Talk Subject: RE: Insert a list into a table - help!!! What database are you using? Jeff Garza Lead Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL

Re: OT: How many in here bother to resell shared webspace?

2002-02-04 Thread Jim McAtee
- Original Message - From: Mark A. Kruger - CFG [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, February 04, 2002 4:21 PM Subject: RE: OT: How many in here bother to resell shared webspace? Ditto - We host managed code only - meaning we wrote or QAed the code on the

System beep

2002-02-04 Thread Ray Bujarski
Does anyone know how to cause a system beep? I am alerting my users with a javascript box that thier session is going to expire if they do not respond to the alert box. However, I need a beep when that box pops up. Thanks, Ray

RE: Custom Tags

2002-02-04 Thread Mark A. Kruger - CFG
Paul, I'd say you are a good candidate for either a stored procedure or query of a query. There's a short article on q of q on our dev resources page if you are interested: http://www.cfwebtools.com/index_dev.cfm Mark -Original Message- From: Paul Giesenhagen [mailto:[EMAIL

  1   2   >