Easy CFLOOP Question
is there a way to find out what row i am on in a cfloop? Like inside my loop, call a condition like this cfloop query="test" startrow="1" endrow="#rows.RecordCount#" cfif cfloop.row EQ 1 We are on row 1 cfelse cfloop.row GT 1 We are not on row 1 /cfif /cfloop Is there a way to do this? Some variable i am overlooking? Thanks Kevin ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFX CyberCash Question....
Ok Basically I am trying to get this darn tag to work, yet I am using the "Test" modes that are supposed to be used with real testing data, yet I still get an error back "faliure-hard" is there anything that I am doing wrong thanks Kevin CFX_CYBERCASH VERSION="3.2" CCPS_HOST="A HREF="http://cr.cybercash.com/cgi-bin/"http://cr.cybercash.com/cgi-bin//A" CYBERCASH_ID="test-mck" MERCHANT_KEY="key-test-mck" MO_ORDER_ID="1234567890" MO_VERSION="3.2.0.2" MO_PRICE="usd 12.34" CPI_CARD_NUMBER="4111" CPI_CARD_EXP="01/99" CPI_CARD_NAME="John Doe" CPI_CARD_ADDRESS="11th Street" CPI_CARD_CITY="Seattle" CPI_CARD_STATE="WA" CPI_CARD_ZIP="98119" CPI_CARD_COUNTRY="USA" OutputPOPQuery="pop" ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Looking for low cost CF host
Just looking for a lowcost CF host that is reliable, and that i can have multiple domains, like a Virtual Private Server. Any suggestions? The sites would not be "heavy" traffic sites. thanks kev ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Looking for low cost CF host
Thank you all so much for your suggestions, i will take all of the comments into considerationand once again, i think all of you who have contributed to my question. Kevin ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFLOOP output Question
Ok, what I want to do is output a query to two tables side by side. Now i tried this but it doesn't quite work well. Any suggestions? cfquery datasource="data" name="information" SELECT * FROM Table /cfquery cfset firstrow = #information.RecordCount# / 2 cfset secondrow = (#information.RecordCount# / 2) + 1 cfloop query="information" startrow="1" endrow="#FirstRow#" output table /cfloop cfloop query="information" startrow="#SecondRow#" endrow="#information.RecordCount#" output table /cfloop Thanks Kevin ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Cfloop Output Question
Well my question was how can i split up the query so it will output the data dynamically. kev ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Cfloop Output Question
Ok, what I want to do is output a query to two tables side by side. Now i tried this but it doesn't quite work well. Any suggestions? cfquery datasource="data" name="information" SELECT * FROM Table /cfquery cfset firstrow = #information.RecordCount# / 2 cfset secondrow = (#information.RecordCount# / 2) + 1 cfloop query="information" startrow="1" endrow="#FirstRow#" output table /cfloop cfloop query="information" startrow="#SecondRow#" endrow="#information.RecordCount#" output table /cfloop Thanks Kevin ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Question About Time Adding
THANK YOU ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Question About Time Adding
How would i add 3 hours to the current time? i thought i could do this, but it did not work... #DateAdd('HH', '3', Now())# Thanks Kev ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Need some guidance on a CFPOP question
Ok, can i do this to determine if someone has logged in correctly??? cfpop SERVER="1.1.1.1" USERNAME="[EMAIL PROTECTED]" PASSWORD="password" NAME="check" cfif check.RecordCount EQ 1 Good Login, Proceed cfelse Bad Login, Redirect /cfif Can i do that record check? kev ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Web Templates
if you must look at some generic layouts check this site out http://www.selectaweb.com nothing great here but i saw a lot of mixed up ones... kev ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Web Templates
Wow, I haven't seen that word for a long long time "FrontPage" haha ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: GetMetricData( SAY WHAT??? )
Hey buddy, try this GetMetricData(PerfMonitor) Kev ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: Who's hacking around ???
Brian, Do some searches on google.com with those full file names, you'll get some "VERY" interesting results. Kev ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: Who's hacking around ???
Actually Brian The Sysmng.exe is a trojan virus my friend ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFIF
--part1_75.ca0f6c5.2751e531_boundary Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit I know if you are using CFIF like in a CFIF statement, you can do it this way... sample.cfm?action=xyz cfif action IS "xyz" Send Me to This URL cfelse Send to other URL /cfif Kev --part1_75.ca0f6c5.2751e531_boundary Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: 7bit HTMLFONT COLOR="#008000" SIZE=2 FAMILY="SANSSERIF" FACE="Verdana" LANG="0"I know if you are using CFIF like in a CFIF statement, you can do it this BRway... BR BR BRsample.cfm?action=xyz BR BRlt;cfif action IS "xyz"gt; BR nbsp;nbsp;nbsp;nbsp;Send Me to This URL BRlt;cfelsegt; BR nbsp;nbsp;nbsp;nbsp;Send to other URL BRlt;/cfifgt; BR BRKev/FONT/HTML --part1_75.ca0f6c5.2751e531_boundary-- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Advanced SQL Question
Ok, this is a simple yes - no question can you remotely query a DB? Like if i wanted to query a DB from an IP from a different IP, is that possible? Thanks kev Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
(no subject)
I am looking for a Cold Fusion hosting company that would offer me this : http://www.myname.com 20 megs space 1 ODBC CF of course 3 - 5 email boxes SSL Does anyone know of a cheap place to do this??? thanks kev Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Random Record
How could i select a random record from a table? Like to set my query as cfquery datasource="mine" name="selectrandomrecord" SELECT * FROM Table WHERE RecordID = ?? cfquery Anyone know how to do this? thanks kev -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Random Record
well what i want to be able to do is like show a random quote from a table of quotes Now some may be deleted, some may be added, in which the cfset Random = #RandRange(1, table.RecordCount)# would not work because the "ID" numbers in the table would be changing, is there a way to specify like a certain Row number in my SQL WHERE statement? like... cfquery datasource="ds" name="random" SELECT * FROM Quotes WHERE ***TableRow = Random Row*** /cfquery can that type of function be completed??? kev -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Simple SQL Question
Ok I want to "conjugate" 3 fields when i am inserting into a database. this is what i have, but it won't work, am i missing something??? cfquery datasource="data" name="add" INSERT INTO Data(data1) VALUES('#FORM.dat1# #FORM.dat2# #FORM.dat3#') /cfquery ? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFHTTP question
Is there a way to actually extract information from URL's, like only the information you want, instead of the other stuff that you don't want? Kevin -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Calculators
Just looking for a list of calculators that have been done in CF??? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Question about Dynamic List Box
Ok, this is what i am trying to doI want to look through my records in a table called Buttons. There is a field in the Buttons Table named Location. This field contains either a 1, 2, 3, 4, 5, or 6. What i want to do is dynamically populate a list box of the numbers that are NOT in the database. This is what i have so far, but i get messed up outputs. can someone help me please cfquery datasouce="data" name="info" SELECT * FROM Buttons /cfquery select name="Location" cfoutput query="info" cfif info.Location IS "1" cfelse option value="1"1/option /cfif cfif info.Location IS "2" cfelse option value="2"2/option /cfif cfif info.Location IS "3" cfelse option value="3"3/option /cfif cfif info.Location IS "4" cfelse option value="4"4/option /cfif cfif info.Location IS "5" cfelse option value="5"5/option /cfif cfif info.Location IS "6" cfelse option value="6"6/option /cfif /select Now is there something i am doing wrong? should i be using a CFLOOP instead Help me please Thanks Kev -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Need help on CFFILE
Ok, what i am trying to do is let a person upload two different picture files Now i want to append some text to the name of the file that they are uploading is there a way to do this? i am using this, but it's not working cfset RegularPhoto = "#FORM.RegularPhoto#regular.jpg" cfset File.ServerFile = #RegularPhoto# cffile Destination = "D:\pictures" ACTION = UPLOAD FILEFIELD = "RegularPhoto" ACCEPT = "image/jpeg, image/jpg, image/pjpeg" ?? is there something i am doing wrong or not including? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Question about CFFile???
Ok, what i am trying to do is let a person upload two different picture files Now i want to append some text to the name of the file that they are uploading is there a way to do this? i am using this, but it's not working cfset RegularPhoto = "#FORM.RegularPhoto#regular.jpg" cfset File.ServerFile = #RegularPhoto# cffile Destination = "D:\pictures" ACTION = UPLOAD FILEFIELD = "RegularPhoto" ACCEPT = "image/jpeg, image/jpg, image/pjpeg" ?? is there something i am doing wrong or not including? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Question about Multiple Order By
Ok, can i do this? I mean i want to order by name first, then i want to orderby city, so if we have kevin and john in seattle, i want to be able to sort them accordingly. So is it possible to do two order by commands within the SQL statement? -kev -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Question about Multiple Order By
oh my gosh, DUH! Thanks a bunch man. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Ok....
I would like to know if there is a way that when i initalize my application, that my URLToken would change after 30 minutes within the same browseris there a way to do this? I want it to refresh to the next one in line after 30 mins. -kev -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
MIMEATTACH
Ok, what i want to do is browse a file from a form. Then process the form to the next page which will use CFMAIL. In this CFMAIL tag i want to use the MIMEATTACH command and attach the file from the previous formpage (the one i was able to browse the file for) and when i do this, i get this error : Error Diagnostic Information MIMEATTACH An invalid file name (C:\docu\pcmcia.txt) was specified in the MIMEATTACH attribute. Please verify that this file exists and that the ColdFusion service has the privileges required to access it. The error occurred while processing an element with a general identifier of (CFMAIL), occupying document position (75:1) to (81:27). Date/Time: 06/29/00 03:12:38 Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows 95; DigExt) Remote Address: 172.155.77.252 HTTP Referer: http://www.ezwebfusion.com/jobapplication/apply.cfm Template: D:\home\ntcf2f251\jobapplication\sendinfo.cfm Am i doing something wrong -kev -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Looping through an Array
Is there a way that i can loop through an array and display all the items kev -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Looping through an Array
Thank you so much !!! :) -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Looping through an Array
my C++ skills failed to come back to me for a few mins -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Ok here is a question about Forms...
Ok, what i am trying to do is make an imagemap that will A) allow a submit to Login, and B) allow a submit to signup. Is there anyway possible to do this inside a form with an image map, somthing like a Javascript with an onClick="Submit()" or something like that? can someone help me? kev -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Inserting Multiple Values into One Database Field
Ok, what i am trying to do is add a column in my database that would contain "Keywords" for a search. What i am trying to do is add values from the data entered in the form from the previous page to one field in the database I only get a value of "-1" ? is there something i am doing wrong??? CFQUERY datasource="search" INSERT INTO search(keywords) VALUES('#name#' AND '#address#' AND '#phone#') /CFQUERY Help? -kev -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Inserting Multiple Values into One Database Field
hey there, thanks for the Tip Anthony, but when I search like two words, it won't pick it up, it only picks up the first word i put in my search box. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Form to CFMAIL Sending Attachment Problem
Ok what i am trying to do is send a "resume" document from a file field in a form, to the next page which will process it as a MIMEATTACH in the CFMAIL Tag. For some reason, it does it correctly, but it does not show the right file attached, all it shows is a .tmp file. Can someone help me? -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Shopping Cart Question
Well, I'm just wondering what is everyone's most recommended shopping cart application that is OPEN SOURCE? Thanks Kevin -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Double Output Problem
CFQUERY NAME="Products" DATASOURCE="shopping" SELECT Products.ProductTitle, Products.CategoryID, Products.ProductID FROMProducts, Category WHERE Products.CategoryID = #URL.CategoryID# /CFQUERY head titleUntitled/title /head CFLOOP QUERY="Products" CFIF Products.ProductID GT 1000 CFBREAK /CFIF CFOUTPUT #Products.ProductTitle# /cfoutput /cfloop OK there is a big problem with this, it wants to output 2 times, so if there is just one product to return say "Paper", it will return this value twice, is there an error in my code??? -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Shopping Cart Question (For Everyone)
Well, I'm just wondering what is everyone's most recommended shopping cart application that is OPEN SOURCE? Thanks Kevin -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: cfHTTP Authorization error - Directory access not allowed
works fine for me also -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.