Hi, ... if "var" is not defined the query will result in SELECT * FROM tbl WHERE AND .... which can not work. You need to insert a dummy clause to get a...
Hi, I have a form that lets the user sign up and choose their own user name and password. I have set the user name as the primary key in my db. The problem i...
I am using CFX_Image to create 130x100 thumbnails of larger images. Works greate but it leaves a large grey border around the thumb, reducing the ablity to...
Hi All, I am new to Cold Fusion and was wondering if someone could help me out with the following: - 1. Is there a site where I can download the Cold Fusion...
ColdFusion Hosting Providers ColdFusion Hosting Providers' List brought to you by *** ColdFusion-HowTo: Yahoo's No. 1 and the biggest group for ColdFusion...
coldfusion-howto@yaho...
Jun 3, 2002 4:01 am
7707
If u buy the actual software it can cost up to 4 grand i believe depending on the version and upgrade packages. if u want to do practice for urself i got one...
Hello, how can I read the value off the SessionTimeout before the value is reseted or from all sessions. not from clientvars I want know how long is no new...
I'm really racking my brain here... and I'm sure I'm missing something obvious. I have a form, that is being generated dynamically: <FORM method="post"...
I need to display two distinct datasets on a graph. The data is gathered from two queries. Everything I have read has only had one line on the chart but said...
I have a numeric value whose 15th digit I need to multiply by 2 (yes, Mod 10 - going a bit Luhn-ey here) #MID(NUMBERFORMAT(MCNUM),15,1)# When I try to multiply...
Try this #Evaluate(2 * NumberFormat(Mid(MCNUM, 15, 1)))# That may work for you Remy ... From: <jschlosser@...> To: <coldfusion-howto@yahoogroups.com> Sent:...
Remy
rune.song@...
Jun 3, 2002 3:39 pm
7715
This works for me: <cfset mcNum = "1234567890123456"> <cfset num15 = MID(MCNUM,15,1)> <cfset newNum = num15*2> <cfoutput>#num15# * 2 = #newNum#</cfoutput> Not...
Duane Boudreau
duane@...
Jun 3, 2002 3:40 pm
7716
Close - got it with this: #Evaluate(MID(NUMBERFORMAT(MCNUM),15,1)*2)# JoAnn A. Schlosser Senior Consultant National Package Implementation Group Grant Thornton...
Are you trying to do your multiplication inside a CFoutPut or quoted assignment? Duane ... From: jschlosser@... [mailto:jschlosser@...] Sent: Monday,...
Duane Boudreau
duane@...
Jun 3, 2002 3:48 pm
7718
The number is 16 digits long and without using numberformat, the 15th digit is the + in scientific notation. Using numberformat, I got a 16 digit number....
inside cfoutput - no quotes, these are numbers. JoAnn A. Schlosser Senior Consultant National Package Implementation Group Grant Thornton LLP Alexandria, Va....
Hi, ... You can't do that in a line chart with CF 5. CF MX can do it with CFCHART. But, you could choose another chart type (e.g. bar chart) and assign the ...
How can I call on a client variable? I have a client ID stored in client.id... and I want to built a query that says 'pull name where client.id=db.id' How can...
<cfquery name='getyadayada' datasource='xyz'> select yada from mytable where id = #client.id# </cfquery> Make sure your client.id datatype is a number, or...
Wow JoAnn, thanks! I'm feeling rather silly right now... I'd tried this one 8 ways from Sunday and for whatever reason, was wrong every time... on something...
I started out like that - couldn't multiply 2 numbers this morning. I'm going home! JoAnn A. Schlosser Senior Consultant National Package Implementation Group...
70 Fields seems like way to many, are you normalizing your db tables... If not the best way to normalize tables is to look at all your fields and move the ones...
