Search results for query: *

I have a regular expression in which I want to select all links where there is index.cfm but want to ignore all where there is index.cfm/accounts or index.cfm/tax I don't know how to negate an expression for index.cfm/accounts or index.cfm/tax but the other part of expression is like that...

I have a table category and content category table Table id parentid catname cattype contentid 1 0 index category 0 2 6 cat1 category 0 3 2 page1 content 1 4 1 page2 content 2 5...

I am trying to output a query to Excel by using <cfcontent type='application/vnd.ms-excel'> I output the data in html <table and <td etc. It outputs the content nicely except the number 8111111111111111 becomes 8.11111E+15 and if I try to format it in Excel, it formats it but becomes...

I generate the report on referers and hits to my site. Recently I got a referrer in my report from a site which is not a good site and no way it could have a link to my site. As far as I understand, a site only becomes a referrer because its URL was set in the cgi.http_referer variable...

Hi The structure of my XML is <Sales> <sale> <items> <item> <id>1</id> <saleid>5</saleid> </item> <item> <id>2</id> <saleid>5</saleid> </item> </items> </sale> <sale> <items> <item>...

Hi I have select box and onchange of this selectbox, in javascript function to which I pass optionid, I run <cfwddx action="cfml2js" input="#Getvalue#" toplevelvariable="options"> Getvalue is a query which selects all the options and using wddxRecordset_findValue in javascript, I get the...

Hi all In my website, I provide a button for users to print a page. Is there any way that if the page is printed, it should mark in database as 'Printed'? Thanks

Hi I am using confirm(Are you sure you wnat to do it?) in javascript. The dialog box in confirm shows two buttons - Ok and cancel. By default, the focus is on Ok. I want to change the default focus to Cancel. How can I do it? Thanks

My SQL query is SELECT distinct a.optionid,b.id,optionname FROM Price a Right JOIN Option_Type b ON a.optionid = b.id WHERE a.HId = 3 Price table stores the options for the HId 3 along with the price. In Option_Type table, I have options but no main HId field. If I have added price for...

Hi all I have a form with a select box with size options in it and there is another select box for the user to say if he wants to his own custom sizes. If user selects yes from this second select box, two text fields should be displayed for the user to input his own values of width and height...

Hi all I submit a form and after form is submitted, check for the record in database with the given id and if exist, alerts the user using javascript and only if user confirms .. save the information in database else just go to a different location. But what is happening- is that it alerts the...

Hi I have a select box of country, on selecting a value in this select box, onChange event it populates a multiple selection select list for states and on selecting values in there, onChange again it populates a multiple selection select list for cities. It is all working well except when I...

Hi all I have an online shop site. It works well till it enters the secure area in IE 5.0. It works well in all versions of IE after IE 5.0. After entering secure area, page is lost. It says - The page cannot be displayed. Basically http:// does not get switched over to https://. Any ideas...

Hi all A page is built programatically and the logic to built and to display the page has been put into <span> tag. On clicking a button, it should open a new window with all the information within <span tags. This works some times and some times, it just opens a blank window. <script...

Hi everyone, I have preloaded the images and then view the bigger image in a new window. I have a page with number of images and on a image click, I call function PopImage('imagename'). The problem is that if I have clicked on an image and viewd it in a new window and that window is still open...

I am working in Cold fusion and Access. I have a list storing countrycodes like AU,NZ etc. I store it in attributes.cntrylist I listqualify this varibale so as to make it like 'AU','NZ' Then run a query like this: <cfparam name="attributes.cntrylist" default=""> <cfset cntrylist = listqualify...

Hi I want to schedule a task in Coldfusion. I have tried scheduling it using code and also using cfide but not able to do it. I have no clue what could be the problem. My code is like this: &lt;cfscript&gt; End_Time = DateAdd(&quot;y&quot;,1,now()); Start_Time = now(); schedulepath =...

Hi I need to alter a table and I am using MYSQL database. I want to add an ID column with auto increment. ALTER TABLE tablename ADD ID INTEGER NOT NULL In my table, there are already 80 records. What I want is that when the table is altered, the ID column should have value auto incremented...

Hi I have a website running on ColdFusion and MySql. The site works fine if I give url like http://myserver/sitename/index.cfm but if give the url as http://myserver/sitename/, the homepage is displayed but any other funtionality does not work e.g from homepage I am trying to add an item to...

SELECT ProductGroupId,ObjectId,GroupName,Featured,Hidden,CreatedOn,DisplayOrder, count(productid) as cnt FROM ProductGroup a, product b WHERE ObjectId = 31 a.productgroupid = b.productgroupid GROUP BY a.Productgroupid This query is not correct because Groupby is only on one field and...