Search results for query: *

I need to convert this asp code to coldfusion. ChartFX1.Series(0).Volume = 100

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=&quot;frmupload&quot; action=&quot;upload.cfm&quot; mehod=&quot;post&quot;> <input type=&quot;File&quot; name=&quot;testfile&quot...

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.

try this one <cfquery name=&quot;View&quot; datasource= MyDatabase> SELECT MAX (inventory_number) AS ID FROM tblInventory WHERE item_number= '#URL.ItemNo#' </cfquery> <cfoutput query = &quot;View&quot;> <cfset mymaxid = #ID# - 1> </cfquery> <cfquery...

you need to add % at both ends %#keyword#% like this <CFQuery name=&quot;Q_Users&quot; datasource=&quot;DSN_IXS&quot;> Select * From Users Where User_ID In (#Category#) And Contents LIKE '%#Keyword#%' </CFQuery>

you need add % at both ends %#keyword#% like this <CFQuery name=&quot;Q_Users&quot; datasource=&quot;DSN_IXS&quot;> Select * From Users Where User_ID In (#Category#) And Contents LIKE '%#Keyword#%' </CFQuery>

oops . typo mistakes in second query i mention. in where condition i mention a.id = but it is a.nid

Ok, if you want keep the same table relation, try this one. <cfquery name = &quot;xyz&quot; datasource=&quot;zbz&quot;> 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...

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...

<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>

calista, if you specify full path instead of relative path for variable application.rootpath, the it works from any directory. <cfset application.rootpath = &quot;http://.......&quot;> or <cfset application.rootpath = &quot;D:\test\test....>

Try this Onclick=&quot;location.href='FindForm.cfm?IFINDREC=document.formname.ifindrec.value&findby=d&quot; replace the &quot;formname&quot; with form name specified in form tag. Then you should able to get the value for #ifindrec# in findform.cfm

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

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...

Using this #URLDecode(urlEncodedString)# you will get decoded value

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 &quot;Shipt&quot; field you will get this error. you may have to use left function to truncate the field value while inserting.

Try this one <CFSET d = StructDelete(session, &quot;Username&quot;, &quot;True&quot;)> <CFLOCATION url=&quot;Login.cfm&quot;>

this will work #replace(queryname.variablename, &quot;,&quot;, &quot;, &quot;)# You are replacing comma by comma and a space.

Embed the javascript code in cfoutput and use #coldfusionvariable#. <cfoutput> <script language=&quot;javascript&quot;> window.open(&quot;something.com&quot; #yourvariable#) </script> </cfoutput>

good deal