Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
ChartFX1.Series(0).Volume = 100
I need to convert this asp code to coldfusion. ChartFX1.Series(0).Volume = 100 -
CFFILE upload problem
I am trying to upload a file. But i am getting an error, it is not detecting the input file field parameter. Any Help? Here is my code. first page <form name="frmupload" action="upload.cfm" mehod="post"> <input type="File" name="testfile"... -
ODBC Error Code = 37000 (Syntax error or access violation)?
It is not the coldfusion problem. i tried to run the same sql statement on the ms access data base, and i got the same error. you may have to specify the datatype for all fields and specify number as datatype instead of integer. -
Aggregate function in CF Update Query
try this one <cfquery name="View" datasource= MyDatabase> SELECT MAX (inventory_number) AS ID FROM tblInventory WHERE item_number= '#URL.ItemNo#' </cfquery> <cfoutput query = "View"> <cfset mymaxid = #ID# - 1> </cfquery> <cfquery... -
CFQuery And S.Q.L. 2000 Server
you need to add % at both ends %#keyword#% like this <CFQuery name="Q_Users" datasource="DSN_IXS"> Select * From Users Where User_ID In (#Category#) And Contents LIKE '%#Keyword#%' </CFQuery> -
CFQuery And S.Q.L. 2000 Server
you need add % at both ends %#keyword#% like this <CFQuery name="Q_Users" datasource="DSN_IXS"> Select * From Users Where User_ID In (#Category#) And Contents LIKE '%#Keyword#%' </CFQuery> -
Urgent, Can't get this grouping to work...
oops . typo mistakes in second query i mention. in where condition i mention a.id = but it is a.nid -
Urgent, Can't get this grouping to work...
Ok, if you want keep the same table relation, try this one. <cfquery name = "xyz" datasource="zbz"> select a.id as groupid, a.newstitle, b.generalcategory, c.region, d.learningsegment, e.businesssector from news a, gc b, re c, ls d, bs e where a.id = b.nid and b.nid = c.nid... -
Urgent, Can't get this grouping to work...
this is very straight forward. You required only group because all the four tables are dependents to the News table. May be your table designing is wrong. I think your requirement is like this. gc should depend on the news table. re should depend on gc table. ls should depend on re table. bs... -
Query a SQL Server
<cfoutput>#products.CatID#</cfoutput> ---- this is wrong, you should not use the table name, rather use need to use the query name mention in the cfquery attribute, like this <cfoutput>#Testing.CatID#</cfoutput> -
Defining #Application.RootPath#
calista, if you specify full path instead of relative path for variable application.rootpath, the it works from any directory. <cfset application.rootpath = "http://......."> or <cfset application.rootpath = "D:\test\test....> -
Get value problem
Try this Onclick="location.href='FindForm.cfm?IFINDREC=document.formname.ifindrec.value&findby=d" replace the "formname" with form name specified in form tag. Then you should able to get the value for #ifindrec# in findform.cfm -
cfquery problem
I think you are losing single quotes. you may have to use preserve single quotes, urlencode functions in first page and urldecode function in the next page -
session time out
SoftIDEA, MY situation is diff. My application is used by CSRs. They would like get the alert notification because they handle multiple applications and some times they minimize this app. and work on other app., but they dont want lose the unsaved data. I am displaying an alert 5 minutes before... -
encode and decode
Using this #URLDecode(urlEncodedString)# you will get decoded value -
ODBC Error!!
I think your are inserting/update a field with the size larger than specified in table. For example if you are inserting more than 2 characters for "Shipt" field you will get this error. you may have to use left function to truncate the field value while inserting. -
Deleting Session Variables on Logout
Try this one <CFSET d = StructDelete(session, "Username", "True")> <CFLOCATION url="Login.cfm"> -
help with format text in CF
this will work #replace(queryname.variablename, ",", ", ")# You are replacing comma by comma and a space. -
pass CF variable to Javascript Pop-up window
Embed the javascript code in cfoutput and use #coldfusionvariable#. <cfoutput> <script language="javascript"> window.open("something.com" #yourvariable#) </script> </cfoutput> -
