Ask a Question related to Coldfusion Database Access, Design and Development.
-
Knum #1
Quick CEILING question
De query <cfquery name='UpdateRating' datasource='#dSn#'> update tableName
set columnA = CEILING(columnA - 1) , columnB = CEILING(columnB + 1)
where id = 89 </cfquery> I can't\don't seem to use\ing CEILING correctly. I
want to try and use the Transact SQL numerical function of CEILING to keep
columnA from ever going negitave. BTW, yes I suck and am using MSAccess as my
DS. I can ROUND but I can't CEILING... Am I just syntaxually-tarded.
Knum Guest
-
very quick question
In my database a field is designated as 0 or -1 . When i make my form how do i set up the drop down menu so that the user chooses yes or no and... -
quick MX question....
how do you get rid of that window on the right where it says 'color swatches', 'components', etc.. it really bothers me, it makes the working area... -
Quick question
if you want to select top 100 records, you will use SELECT TOP 100 * FROM tableName Is there anyone knows how to find bottom 100 records? ... -
A Quick Question
Does anyone know if it is possible to create a Flash movie that has the ability to let the user click on a button to begin the installation of a... -
QUICK SSA QUESTION
AIXers, I'm looking for a quicker way to determine the physical locations of ssa drives in a SSA drawer w/o having to use diag/ssa service aides... -
Knum #2
Re: Quick CEILING question
Update: I am still looking and I think that CEILING it not the right tack for
me to turn to... I am only dealing with the number 1. That is adding it or
subtracting with the number one. So I came up with a dim-witted, dull,
feebleminded, half-witted, imbecile, moronic, simpleminded, unenlightened,
reactionary, obtuse, stupid, thickheaded, unenlightened, uninformed,
underdeveloped, undeveloped and unprogressive way of doing it. <cftransaction>
<cfquery name='UpdateTable' datasource='#dNs'> update tableName set ColumnA =
ColumnA - 1 where id = 89 and ColumnA <> 0 </cfquery> <cfquery
name='UpdateRating' datasource='ourgardens'> update Books set ColumnA =
ColumnA + 1 where id = 89 and ColumnA <> 32767 </cfquery> </cftransaction>
Still doesn't solve the root problem of not allowing the column to fall into
negitave numbers. Please help... I can't find Jack or his brother Dit-a-Lee on
the net about how to keep it positive.
Knum Guest



Reply With Quote

