LinkPoint Gateway?

2005-04-24 Thread ColdFusion Developer
Anyone use Linkpoint Gateway services with their API to process online credit cards? I am trying to run some test transactions and wanting to process a valida transactions to test the status and download pages but having problems. Anyone have a template they use for viewing the declined/fraud

Access and CF

2005-04-03 Thread ColdFusion Developer
Does anyone use an Acess DB with a table that contains a field type of MEMO? If so, can you check to see if any data contained there has more than 255 characters? Everytime I attempt to enter 300+ characters into the field I get the error: invalid precision error The field type is in fact a

Re: Access and CF

2005-04-03 Thread ColdFusion Developer
Thanks, That did it. I was using the normal CF_SQL_VARCHAR Matt Robertson wrote: Sure it works fine. You must use cf_sql_longvarchar as the cfsqltype. cf_sql_clob might work as well but cf_sql_longvarchar cfsqltype is a gaurantee.

Re: SQL Error

2005-04-01 Thread ColdFusion Developer
But there is no decimals in this. Adrian Lynch wrote: I'm not too hot with Access but if that were SQL Server my first thought would be to look at decimal datatypes. Ade -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: 01 April 2005 23:27 To: CF-Talk Subject: SQL

Re: SQL Script

2005-03-30 Thread ColdFusion Developer
I know this is MS SQL Server related but for a CF app. I have a SQL script that creates the following table but produces the following warning. Any idea what this means and how I can get around it? CREATE TABLE [dbo].[FILE_CATEGORY] ( [ID] [int] IDENTITY (1, 1) NOT NULL , [CATEGORY]

Combininig Datasources in 1 CFQUERY

2005-03-25 Thread coldfusion . developer
Hello, Some of our Access tables are being moved to our SQL Server, while some remain in Access. I have two datasources that separate the SQL from Access. However, I run into some code where tables from each of the datasources are in one CFQUERY within a join. Can I indicate multiple

Re: race condition here?

2005-03-24 Thread ColdFusion Developer
Here is a question for you Tony, sorry not a resolution for your issue, when you are dealing with locales as you described, did you do a template which contains all the language based labels and assigned them as variables to be used? such as: English Template: varSubmit = Submit Spanish

DWMC2004 Can save files?

2005-03-23 Thread coldfusion . developer
Does anyone know what's causing this? I get an error message when I try to save edited files in DWMX2004. While executing receiveArguments in File_Save.htm, the following JavaScript error(s) occurred: at line 75 of the c:\Program Files|Macromedia\DreamWeaver MX

Search and Replace DWMX 2004

2005-03-22 Thread coldfusion . developer
All, I want to replace a datasource that's listed through many DWMX sites. I can do the search and get a list without any probelms. In fact, I can do the replace all and it will replace all the references for me. My question, the issue is how do I get the multiple files that have been changed

Runing VBv6 Apps from within CF

2005-03-22 Thread coldfusion . developer
Has anyone ported VB6 applications to the Web through CF pages? We have a bunch of Visual Basic v6 applications that need to be ported to our Web site. Has anyone had any experience do this? I'm the CF developer and we have another person that is the VB developer. Between the two of us, we

IIS CFMX6.1

2005-03-12 Thread ColdFusion Developer
Does anyone know if it is possible in IIS to create the virtual directory pointing to a CFMX 6.1 application under: CFUSIONMX \ WWWROOT \ THISAPP Catch is, I also have CF5 co-existing on the machine. and IIS home directory points to a folder of wwwroot which is mainly CF5 applications. I

Re: IIS CFMX6.1

2005-03-12 Thread ColdFusion Developer
directory action. jonese On Sat, 12 Mar 2005 07:30:59 -0500, ColdFusion Developer [EMAIL PROTECTED] wrote: Does anyone know if it is possible in IIS to create the virtual directory pointing to a CFMX 6.1 application under: CFUSIONMX \ WWWROOT \ THISAPP Catch is, I also have CF5 co-existing

Re: when delivering a file with cfcontent.

2005-03-07 Thread ColdFusion Developer
Set the MIME type to unknown Protoculture wrote: On some windows machines it gives the user the option to save or open, on others it opens up in the default application immediatley ( ie, word. Opens open in a word like interface within the browser ). How can I force to have the default being

Re: Getting Output To Display in Order Based on Calculations

2005-02-17 Thread ColdFusion Developer
You could use the calculated data set, create a new query using QueryNew and then do a Query of Queries (QoQ) and re-sort it that way, then display. A drawn out process but works. Les Mizzell wrote: Page in Question: http://www.cyndustries.com/bugmusic_vote_completed.cfm (Unless you're into

Re: [SOT] Supporting multiple browsers and versions

2005-02-05 Thread ColdFusion Developer
I do all development for FireFox, then fix the little things from IE and NetScape. Thats the only ones I deal with honestly. Dave Merrill wrote: I've been doing intranet work for a while now, where the only browser we had to support was the one that came installed on company PCs. Have recent

Re: CF-based Online Backup System...any thoughts?

2005-01-31 Thread ColdFusion Developer
I also use FTP Voyager for synching files. Personnaly one of the best FTP Programs around. Matt Robertson wrote: Yes, FTP Voyager has a Scheduler that I use all over the place. I have one client who has zillions of PDF's that need to be available for their customers to look in on (an

Oracle Date Field

2005-01-25 Thread ColdFusion Developer
Using a CF Query to add a record to Oracle, I havea date field to add When adding it, it is straightforward, right? When retrieving the date information, I need to do a To_Date function? Is that correct? Been a long time since I had to use Oracle.

Re: Oracle Date Field

2005-01-25 Thread ColdFusion Developer
Thanks, like I said, been a long time since I used it. By chance any website you may have I can reference for more questions like this? Thanks again! James Holmes wrote: INSERT / UPDATE with to_date() SELECT with to_char() -Original Message- From: ColdFusion Developer [mailto:[EMAIL

CardServices / Linkpoint with CF

2005-01-22 Thread ColdFusion Developer
Is anyone using Cardservices (aka. LinkPoint) to process credit card sales on their website? I am trying to set things up and would like some more information that the API manual does not provide. Thanks! ~| Logware: a new and

Help with Dynamic Directory

2004-11-30 Thread ColdFusion Developer
I am working on a script that will dynamically determine where a directory is located within an application. Lets say the structure is as follows: D:\www\myApp\ D:\www\myApp\admin D:\www\myApp\admin\profile D:\www\myApp\images D:\www\myApp\includes D:\www\myApp\users D:\www\myApp\users\profile

CF-DWMX 2004 Design

2004-10-20 Thread coldfusion . developer
All, I have one question. Any direction would be great. 1) Once I use layers to create the structure of a page, I would like to export the details of the layer to a css file and reference an ID in the page. However when I try to export the layer information, it doesn't write to the css file

CF to make Dynamic CSS

2004-10-20 Thread coldfusion . developer
I'm trying to think of a way to change values in a css file using CF. How can I write to a css file? Any thoughts? D ~| Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta

Development Team Advice

2004-09-16 Thread coldfusion . developer
Hello All, 1) Can anyone recommend an application that will manage a CF Web Dev team and keep internal/external customer/clients informed as to deadline extensions and reshuffling of project priorities? Nothing to overkill an preferabley something written in CF that we could modify. If not,

Re: Credit card page processing before error check

2004-08-31 Thread coldfusion . developer
I'm running it from ... input type=Submit value=Submit Order > Ok Without reading that whole page. How are you running these _javascript_s? On form submit or with a button's onclick event? If you are running them onsubmit you are not returning false from what I could gather [Todays Threads]

Frustrated: Help Web Services - Illegal XML character

2004-08-20 Thread coldfusion . developer
I'm sharing data from our database through remote Web Services. This one column with long product description is causing the following error.I've written an TSQL script that when in and removed all instances of amp; and replaced it with and.I run a query against the table and ask it to show me all

Re: Web Services: Sharing Data - E-Commerce

2004-08-19 Thread coldfusion . developer
So I could have them invoke our Web service and pass their order details as required arguments within our Web Service?Then take those values and insert them in our database?It's as simple as that? On Thu, 19 Aug 2004 02:10:52 +, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: What's the

Web Services: Sharing Data - E-Commerce

2004-08-18 Thread coldfusion . developer
All, What's the best way to securely transfer customer's order information from an Affiliate back to our company, the distributor? We are a distributor. We're using Web services to share data with our Affiliates and give them access to our product data related tables in our database.Our

Web Team Project Management App

2004-08-06 Thread coldfusion . developer
Our company is moving from a one man to a three man development team.I would looking for an application that we could use preferable built in CF to help manage incoming project requests and track the progress/stage of each developer. Does anyone have any advice or read any good articles about CF

First Web Service: Data Sharing

2004-07-22 Thread coldfusion . developer
All, One of the columns in my database has charactors in it that the XML just does like.See error below.Is there any way I can tweek the information that's allowed through this process?Someone mentioned that the encoding in the DTD should be changed/altered.This is above me. ?xml version=1.0

Re: First Web Service: Data Sharing

2004-07-22 Thread coldfusion . developer
I applied it here ... !-- WEB SERVICE -- cfinvoke webservice=http://www.oursite.com/New_Product_Submission/cfcs/InventoryDataShare.cfc?wsdl method=entireinv returnvariable=aQuery /cfinvoke cfoutput query=aQuery strong#aQuery.currentRow#/strong #xmlformat(PART_NUMBER)# - br hr /cfoutput AND

Re: First Web Service: Data Sharing

2004-07-22 Thread coldfusion . developer
It turns out that there are charactors within the long description data that contains amp; charactors.I did a search on all the entries using the LIKE predicate and found 2300+ rows contain that charactor. Great! 8-) Now I have to figure out a way to strip out the amp; out of amp; and leave the

RE: Why would CF 4.5.2 suddenly stop processing pages?

2004-07-21 Thread ColdFusion Developer
Check your IIS Settings to make sure you have the CFM parser setup. IIS: Website Properties :Configuration .cfm = D:\CFusion\BIN\ISCF.DLL I am sure it is about the same for CF 4.5.2... _ From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 21, 2004 2:19 AM To: CF-Talk

DWMX WAP Wireless

2004-07-12 Thread coldfusion . developer
I've been tasked convert a few of our Web site's basic functionality to work on a Blackberry.Search for product by part number etc.I've been to BlackBerry's Web site and it looks like I need to develop in Java. Which I'm only a beginner at.I've searched on the Macromedia site without luck. Can I

Re: Load testing

2004-06-18 Thread ColdFusion Developer
Weuse a product called: WebLoad by Radview Software www.radview.com - Original Message - From: Yves Arsenault To: CF-Talk Sent: Friday, June 18, 2004 7:51 PM Subject: Load testing Hello, I was wondering what was the general pratice for testing your app is Is there any way of

Layers and JavaScript

2004-06-03 Thread coldfusion . developer
Hello, I've read where _javascript_s and Layers can cause conflicts.I created a drop down menu from a hyperlink and it doesn't seem to work.I remove the layer or just the CSS link and then the menu works.It seems to have a conflict with the coordinate on the page vs the coordinates within the

Web Services: Shopping cart

2004-05-20 Thread coldfusion . developer
Any ideas would be appreciated, We're sharing product tables info with partners via a Web service.Our partners will be using this product information to populate their database and display data on their Web site. Because we warehouse and drop ship the partner's customer order, we want to capture

CFCOMPONENT/CFINVOKE: Help

2004-05-18 Thread coldfusion . developer
Help I'm using a CFC to create a Web service. One of the columns in my query past through the Web service has HTML tags in the ntext data type column.The Web Service doesn't like it and throws an error for just this column. I think the markup needs to be stripped from the data and then I think

Re: CFCOMPONENT/CFINVOKE: Help

2004-05-18 Thread coldfusion . developer
What error are you getting exactly? You should have no problem returning a string w/ HTML in it. Error Occurred While Processing Request Could not perform web service invocation myFunction because AxisFault faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException faultSubcode:

Re: CFCOMPONENT/CFINVOKE: Help

2004-05-18 Thread coldfusion . developer
At 11:48 AM 5/18/2004, you wrote: You could encode the HTML text, but then you'll have to escape your entities. Not sure how to do that.Can you please give me a quick example. Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: CF_Web_services preparation for consumption

2004-05-18 Thread coldfusion . developer
On Monday 17 May 2004 18:40 pm, [EMAIL PROTECTED] wrote: 1) How can I prevent these Affiliates from using these Web services as live data feeds to populate their Web pages?Can I somehow restrict the number of hits/bytes to these Web services? You want some sort of access control in the main

CF_Web_services preparation for consumption

2004-05-17 Thread coldfusion . developer
All, We're writing CFCs tht will become Web services.These Web services are going to be data exchanges from a few of our database tables.We want the Web Services to be used to access our database information and import the data to their own database.To sign up for access to these Web Services,

Re: Shanje refugees

2004-05-11 Thread ColdFusion Developer
Unlinkearth..(http://www.uplinkearth.com) I have the Quantim plan. WHich allows me, 10 domains and 10 sub-domains. Both Access SQL are available and I have to say, adding Sub-domains on the fly with their control panel is a breeze! Not to mention their support is excellent. Most all cases are

CFXML Query Results to XML

2004-05-11 Thread coldfusion . developer
Hi, I'm testing the ability to export data from a query using CFXML to create an XML file. My questions are ... 1) Is the exported XML file in XHTML format?If not, what DTD is being used? Once the query has been exported to an XML file,I want to send this XML file to someone that's not using

CFC 2 XML - ERROR: Whitespace required before attributes

2004-05-10 Thread coldfusion . developer
I Does anyone know anything about this error.I can't figure it out.Here's my code. CFQUERY name=get_info datasource=#datasource# maxrows=10 Select partno, shortdesc, longdesc, pic, manf, promos, dateAdded, ManHand, OverSized, FreightItem, MotorSportsFlag from inventory /CFQUERY CFXML

Re: CFC 2 XML - ERROR: Whitespace required before attributes

2004-05-10 Thread coldfusion . developer
I've tried all these suggestions and here's what the code look like now. NEW ERROR: Illegal character or entity reference syntax. Illegal character or entity reference syntax. The error occurred in D:\Inetpub\wwwroot\New_Product_Submission\cfcs\CFC_2_XML.cfm: line 23 21 :

CFC 2 XML - ERROR: Illegal character or entity reference syntax.

2004-05-10 Thread coldfusion . developer
Help, Now I get this error.Code is listed after code.Ahh! ERROR: Illegal character or entity reference syntax. Illegal character or entity reference syntax. The error occurred in D:\Inetpub\wwwroot\New_Product_Submission\cfcs\CFC_2_XML.cfm: line 23 21 :

stand_alone_cfapp

2004-04-22 Thread coldfusion . developer
All, I understand that a CF Application needs a Web server and an installation of CF.However, has anyone every built a Cold Fusion application that resides on a CD?Also, has anyone every built a CF app that would store data while off line (no network connection) and then update a datasource once

Re: Good (inexpensive) domain registration

2004-03-18 Thread ColdFusion Developer
You could always register one domain and have many sub-domains from that. All depends on your hosting provider. Example: Single Domain:www.myFamilyName.com Sub-Domains: ryan.myfamilydomain.com one.myfamilydomain.com two.myfamilydomain.com three.myfamilydomain.com four.myfamilydomain.com etc...

RE: detecting print or cancel buttons

2004-01-01 Thread ColdFusion Developer
ent: Wednesday, December 31, 2003 11:50 AM To: CF-Talk Subject: detecting print or cancel buttons I'm calling the print dialog box from my app and I want to detect if print or cancel was selected, how is this done? ~~ Daniel Farmer Coldfusion Developer / Sales / Produ

RE: Weird PC Error - Part II

2003-11-17 Thread ColdFusion Developer
unable to do that since there is only the one strip -- Original Message -- From: Dave Watts [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Mon, 17 Nov 2003 20:03:02 -0500 ANy other ideas before I toss the thing out the window??? You might try

RE: Weird PC Error - Part II

2003-11-17 Thread ColdFusion Developer
Message -- From: ColdFusion Developer [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Mon, 17 Nov 2003 19:59:22 -0500 unable to do that since there is only the one strip -- Original Message -- From: Dave Watts [EMAIL

RE: Weird PC Error - Part II

2003-11-17 Thread ColdFusion Developer
It is after the Installation of the devices and right after it asked for the keyboard language, machine name, as well as the Product Key. Reminder.. This is a LEGAL fully purchased copy of Windows XP. -- Original Message -- From: John Munyan [EMAIL

Previous Row in a table

2003-11-10 Thread coldfusion . developer
Hi, I'm running a query with a specific row ID.From there, I'm trying to extract a previous row's information where the row meets a bit value of 1.Example, (SQL logic written out, pseudo) queryname=pull_info Query all entries from xyz table where xyz_id = value passed from form Once this row

RE: [ OT] Special security Alert!

2003-09-23 Thread ColdFusion Developer
I was one of the few who was getting slammed with those emails from the SWEN.A worm. Now today I am happy once again to say I am still using Microsoft Outlook 2002 and am no longer receiving them. What I did was the following: Updated Windows with all updates (

?id=23

2003-09-12 Thread coldfusion . developer
All, I have an application that passes an id value through a hyperlink that the user clicks on in an e-mail. The id feeds the page and extracts information and populates the form fields with the user's information. THE PROBLEM: If a user is viewing their customized information with their user

Re:?id=23

2003-09-12 Thread coldfusion . developer
Thanks to all for your replies. The encrypt is just what i was looking for. D- encrypt on the way up and decrypt it when you use it on your form page to pull back the record's data Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830

CFCookies and CFLocation

2003-07-25 Thread coldfusion . developer
All, I know it says in the documentation ... Warning Do not set a cookie variable on the same page that you use the CFLOCATION tag. If you do, the cookie is never saved on the browser; therefore, it is of no value. So how can I set a cookie on a processing page that need to have a redirect?

CFCookies and CFLocation

2003-07-25 Thread coldfusion . developer
Dave, Thank you for the reply. I've read the documentation on cfheader and don't see how I could redirect using this tag. Couold you please give me a hint? Thanks. I know it says in the documentation ... Warning Do not set a cookie variable on the same page that you use the CFLOCATION

CFCookies and CFLocation

2003-07-25 Thread coldfusion . developer
THANK YOU! THANK YOU! THANK YOU! THANK YOU! I know it says in the documentation ... Warning Do not set a cookie variable on the same page that you use the CFLOCATION tag. If you do, the cookie is never saved on the browser; therefore, it is of no value. So how can I set a cookie on a

CFMAIL within A CFLOOP - desparate

2003-07-24 Thread coldfusion . developer
Help I'm stumped! A #FORM.text_form_variable# contains a hyperlink that has URL.variable value that needs to be parsed during a cfloop within cfmail tag. The value in the hyperlink is #contain_query_2_loop_though.e-mail_id#. contain_query_2_loop_though is the query I'm looping through.

A scope problem ???

2003-07-23 Thread coldfusion . developer
All, INTRODUCTION: I have an mass e-mail tool that I created and within the outgoing text of the blast, there are hyperlinks. (displayed in a text field - admin tool) In these hyperlinks are #queryname_1.column_name# values. Queryname_1 is the name of the quey I'm looping through to send

A scope problem ???

2003-07-23 Thread coldfusion . developer
Thank you for your question. Here is a better picture of the code ... Look for the *-*for my comments*-* CFLOOP QUERY=blast_going_out !--- SEND OUT E-MAILED LOOP --- cfmail to=[EMAIL PROTECTED] from=XTZ COMPANY subject=My Subscription: #FORM.blast_name_form# #blast_going_out.embl_email# Dear

Sorry Quick SQL

2003-07-16 Thread coldfusion . developer
Hi All, I know this isn't CF but this is the only list I know of. Does anyone know any good SQL lists or a quick answer. Sorry and thanks. I've got a form with multiple check boxes that we want to use to send out mass e-mails to suscribed customers. The sender with slection only the items

Sorry Quick SQL

2003-07-16 Thread coldfusion . developer
I found an answer ... CFQUERY name=blast_going_out datasource=#Data_Source_dev# SELECT * FROM email_blast WHERE 1 = 0 CFIF ISDEFINED (FORM.blast_catv_form)OR embl_sub_trigger = 1 AND embl_ms_brd_cable = 1 cfelseif ISDEFINED (FORM.blast_wireless_form)OR embl_sub_trigger = 1 AND

String help

2003-07-09 Thread coldfusion . developer
Hello, I'm outputing a query and have a part number value. The part number value is syntacically the same, (SSS444BBB) The first part of the part number is three letters, then three numbers. I want to extract the three numbers from this part number. Any suggestions? Thanks D

Sharing Central Applications - Advice?

2003-06-18 Thread coldfusion . developer
Hi, I'm looking for advice on how best to share applications. I have two issues. 1).I want to maintain these applications from one central location. Users use these applications from their own secure sub directory below the webroot. 2).There will be 500 - 1000 users accessing these

Re: Sharing login state among applications in Intranet

2003-06-18 Thread coldfusion . developer
Thanks. This reply gave me a better idea than I first thought of. Instead of creating different directories for each user, create one directory with all the applications and just identify the user by login information. As long as the login allows or prevents access I won't need the separate

CFLOOP, through list, delimiters help

2003-06-04 Thread coldfusion . developer
Help, I'm trying to extract the e-mail addresses from a text file. Here a sample of the text file and the code I have. Each line is separate by a carriage return. I forget what the symbol for the carraige return is which I need for the delimiter. Any help would be great. Ingar Bae

CFLOOP, almost there

2003-06-04 Thread coldfusion . developer
Hi, I I need is some code that will strip out the e-mail address. Ingar Bae Swnary [EMAIL PROTECTED] Ral Diaz Argentina [EMAIL PROTECTED] Cris Grass Uk [EMAIL PROTECTED] Thanks. ~| Archives:

CFLOOP, almost there

2003-06-04 Thread coldfusion . developer
Hi, All I need is some code that will strip out the e-mail address. Ingar Bae Swnary [EMAIL PROTECTED] Ral Diaz Argentina [EMAIL PROTECTED] Cris Grass Uk [EMAIL PROTECTED] Thanks. ~| Archives:

CFLOOP, almost there

2003-06-04 Thread coldfusion . developer
Aren't there any string functions that would take a string and parse out an e-mail address? I don't know how to deal with arrays! Thanks. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription:

RE: CFLOOP, almost there

2003-06-04 Thread coldfusion . developer
Great! This is the closest I've come yet. The problem is the number of charactors on each liine isn't the same. so some lines, I get just the e-mail, others I get the last name and the e-mail address. So close! Something like this? CFSET CRLF = Chr(13) Chr(10) CFLOOP LIST=#emailtext#

Block Competitors from Web site

2003-05-27 Thread coldfusion . developer
Hello, Any have any other creative ideas on how to block competitors from gaining access to a Web site. My idea, which isn't fool proof is to try and find out what their network IP address is and write code in your site wide header to redirect or block traffic from a IP sub set, as long you

CF_CEO_Dynamic_Pull_Down_Menus Client Management ???

2003-03-21 Thread coldfusion . developer
I've got a JavaScript that takes the selection from the first pull down menu and populates the second pull down menu based on the first. The Script works fine and give the result page it's suppose to after submitting the form. The problem is, when you hit the back button, the first pull down

iframe hyperlink

2002-11-19 Thread coldfusion . developer
Thanks in advance. I have a an iframe within a page, there's a hyperlink in the page referenced within the iframe. When I click on the hyperlink, it goes to the page and displays the new page from within the iframe. How do I get the hyperlink in the iframe to push the new page to replace the

Ramdomizing elements in a LIST

2002-11-15 Thread coldfusion . developer
I'm trying to randomize the output of a list within a CFLOOP. Any help would be great. Her's what I have so far. cfloop INDEX=ListElement LIST=John,Paul,Ringo,George CFOUTPUT#ListElement#/CFOUTPUTBR /cfloop D

Ramdomizing output of elements in a LIST

2002-11-15 Thread coldfusion . developer
I'm trying to randomize the output of elements a list. Any help would be great. Her's what I have so far. I have a three cell table that I want to insert a random element from the list, one element into each list without repeating an element. table tr td/td td/td

RE: Ramdomizing elements in a LIST

2002-11-15 Thread coldfusion . developer
Thank you. This might work for my application. How about: cfset list=John,Paul,Ringo,George cfoutput#getToken( list,randrange(1,listlen(list)),',' )#/cfoutput -Original Message- From: [EMAIL PROTECTED] [mailto:coldfusion.developer;att.net] Sent: Friday, November 15, 2002 11:19

Re: Ramdomizing output of elements in a LIST

2002-11-15 Thread coldfusion . developer
PERFECT! Thanks! I ran this on my server, it worked great. - Rick CFSET TheList = John,Paul,Ringo,George TABLE TR CFLOOP FROM=1 TO=3 STEP=1 INDEX=temp CFSET Position = RandRange(1,ListLen(TheList)) TDCFOUTPUT#ListGetAt(TheList,Position)#/CFOUTPUT/TD CFSET TheList

Query Values in CFLOOP _sex

2002-08-19 Thread coldfusion . developer
Hey All, I'm trying to shift/re-assign query values within a CFLOOP. I'm finding that it won't work unless I change the name of the new varibable to a nonquery column name. It works when I add _sex to srf_q2_qnty and change the variable anme within CFSET. I just want to shift the values to

Re: Query Values in CFLOOP _sex

2002-08-19 Thread coldfusion . developer
Sorry for the cheap ploy! Hey All, I'm trying to shift/re-assign query values within a CFLOOP. I'm finding that it won't work unless I change the name of the new varibable to a nonquery column name. It works when I add _sex to srf_q2_qnty and change the variable anme within CFSET.

Re: Query Values in CFLOOP thanks!

2002-08-19 Thread coldfusion . developer
It worked! Thanks a bunch! Working code listed below ... CFSET CountVar = 0 CFLOOP query=standard_market_ALL cfoutputCFSET qdif = #datediff(q, now(), srf_q1_date)# #qdif# strong#dateformat (srf_q1_date, mm/dd/)#/strong #srf_companyname# -

STUMPED! help

2002-08-18 Thread coldfusion . developer
I have a huge Sales Application 99.99% completed and after hours of attempts. I'm stumped on the last part! Please send any help/advice. Thanks. I'm trying to extract values from a query from within a Custom Tag. I can get a record count value, but not a needed date column/value. Argh!

Passing Variables to Custom Tags, Thanks

2002-08-16 Thread coldfusion . developer
Hello, How can I get a #query.colunmname# variable to show up in a custom tag where the query is taking place in the callering template and not within the custom tag? ***FILE_ONE.CFM***calling template*** CFQUERY name=standard_market_ALL datasource=#datasource# Select *

CF_help cflocation with submit name value

2002-07-31 Thread coldfusion . developer
Hi all, I have a form with more than one submit button. Each submit button performs different logic. The logic is performed based on the submit name. input type=submit name=submit1 value=Forecast in Dollars input type=submit name=submit2 value=Forecast in Quantity I need to incorporate

CF_Array_help

2002-06-24 Thread coldfusion . developer
Hey, I'm not good at arrays and could use some help. I'm trying to import a *.csv file with three columns into a table. The csv file look like ... Donna Jackson,[EMAIL PROTECTED] Drew Corporation, Douglas Car,[EMAIL PROTECTED] Drew Corporation, Here's what I have for code so far ... 1)

RE: CF_Forms_in_HTML_E-Mail No Answers yet

2002-06-14 Thread coldfusion . developer
Ryan, You solved it. I was trying to submit from within the preview pane view. Once I openned the e-mail the submission worked. Although it's great you helped me get the form working, now I have to convey to people I send this e-mail to, that they have to open the e-mail in a separate

CF_Forms_in_HTML_E-Mail No Answers yet

2002-06-13 Thread coldfusion . developer
Hello, No one seems to be able to answer this one ... Sending an HTML e-mail using cfmail ... In the HTML E-mail is a basic form ... When I hit submit from within Outlook, the form won't process. Why? CODE: CFMAIL to=[EMAIL PROTECTED] from=[EMAIL PROTECTED] subject=HTML FORM E- MAIL

CF_Dedicated_Hosting_Services

2002-05-21 Thread coldfusion . developer
All, I'm looking at a few dedicated hosting services for a corporate site. Here's a few companies I'm looking at. Please feel free to share good and bad experiences. If there are other great companies, please add them on. www.Cfdynamics.com ... presently in the lead www.Hostmysite.com

CF_CreateODBCDateTime_DUH!

2002-05-02 Thread coldfusion . developer
Ok, I need a second pair of eyes here. THIS WORKS ... CFSET myDate = #CreateDateTime(2002,05,01,14,31,32)# cfoutput#CreateODBCDateTime(mydate)#/cfoutput WHY DOESN'T THIS WORK? where the URL value is ?test=2002,05,01,14,31,32br CFSET myDate = #CreateDateTime(url.test)#

CF_CreateODBCDateTime solution

2002-05-02 Thread coldfusion . developer
Thought I'd share the solution ... CFSET year = ListGetAt(URL.test, 1) CFSET month = ListGetAt(URL.test, 2) CFSET day = ListGetAt(URL.test, 3) CFSET hour = ListGetAt(URL.test, 4) CFSET minute = ListGetAt(URL.test, 5) CFSET second = ListGetAt(URL.test, 6) CFSET myDate = #CreateDateTime(year,

CF_DateTime_Query help

2002-05-02 Thread coldfusion . developer
HELP! I'm trying to match an e-mail address with the exact date and time the record was created as a unique identifier. I'm trying to use the following ODBC value in the this query to extract a unique row. SELECT * FROM crossref_email WHERE crsref_email = '#URL.eml#'

CF_Append_2_Query_Results

2002-04-18 Thread coldfusion . developer
User does a search from a page that queries a table and displays the results. I then have a checkbox next to each result, (for 1 or more result items) each checkbox form value is dynamically assigned key_id value from table. This uniquely identifies each result set. I'm giving user the

CF_Fusebox_Search_Engine_URLs

2002-04-16 Thread coldfusion . developer
Ok, I inherited a site that was built in the Fusebox fashion where all the pages are ... com/index.cfm?param1=valueparam2=value2param3=value3 Besides creating matching static pages, how else can I have different URLs that will work when submitting the site's pages to search engines. Thanks

CF_404_errors_shared_hosting

2002-04-02 Thread coldfusion . developer
This is a shot in the dark ... Our company has a shared hosted site and we want to be able to control the error templates that are displayed when a user gets a 404 error for example. Our hosting company said they CAN'T help us, unless we migrate from a shared hosting to a co-located service.

RE: Q: Looping through a CSV File

2002-03-21 Thread coldfusion . developer
Are these ODBC options available in CFServer 4.5? I have 5.0 (dev server) but our web hosting company is still at 4.5. The structure will always be the same but the file name is going to change though. I am backing up the old file before I push the new file up. Thanks, Jason Larson

SQL Error, I know

2002-03-19 Thread coldfusion . developer
I know this is suppose to be for CF stuff, but I know someone can help with this. I'm under the gun here. I'm getting this SQL 2000 error message when I try to add a new column to an existing table that's filled with data. ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not

RE: SQL Error, I know

2002-03-19 Thread coldfusion . developer
Not quite sure. Our ISP is hosting our CF Web site along with SQL 2000. The ISP's Adminsitrator is trying to tell me it's a Professional Services request and wants to charge me $200/hour to fix the problem. D- nice one - seen this before. It aint your disk that is full it's your

RE: SQL Error, I know

2002-03-19 Thread coldfusion . developer
Is there any solution? If you are running SQL on SBS there is a maximum size to your filegroups (which you can easily reach). It sucks believe me -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 19 March 2002 16:02 To: CF-Talk Subject: RE: SQL Error, I

RE: SQL Error, I know

2002-03-19 Thread coldfusion . developer
How's this for customer relations ... e-mail from hosting company's DBA ... Your database is not configured to grow automatically. You pay for a set size monthly and that is all that is available. You can request more disk space if you need it, but that's up to you. This is definitely

<    1   2   3   4   5   >