Ask a Question related to Coldfusion Database Access, Design and Development.
-
keller18 #1
Removing .0 from record
Another easy one, I hope.
I have records in a database that read like 3654.0
How can I get CF to remove the .0 for me, so I can access an image called image3654 ??
keller18 Guest
-
Find record w/ conditions met in the same child record
I'll use 2 files to demonstrate my question. The first file is Animal. It has 4 fields. Id (serial number) ZooId (number) Name (text) Food... -
using dropdown box to display db record & update record
Hi Folks, I have a web database written in asp and using access97. I have many projects, but each project is being held responsible by a person.... -
Stop adding record in subform after record count = 1
Can someone help in in what to put after the THEN statment to allow one entry if the Record count is =>1 in the Before insert or should I set the... -
Adding a new record when the record source is a query.
Hello All, I have a form that runs a query. The reason it runs on a query is because prior to it opening I have a form from which you can pick... -
Removing desktop icon from one account is removing from all accounts
Using XP Professional. I want the Guest account to have only a few icons. The other two accounts should have many more. When I remove the icon... -
name=Azpen #2
Re: Removing .0 from record
CF function NumberFormat(<number>,) will do it for you. define "0000" as the
<cfset readNumber = NumberFormat(<number>,)>
<cfset imagecalled = image&""&readNumber>
name=Azpen Guest
-
Dan Bracuk #3
Re: Removing .0 from record
I'd use the round function myself. Less typing, than numberformat.
Dan Bracuk Guest



Reply With Quote

