Search results for query: *

I'm working on a login page. My previous plan was to create a session variable called name which would be set to either "guest" or the member's name depending on whether the login was successful. I've decided now to change this and I'm only going to create a session variable only if the login...

I am thinking of implementing some javascript code to automatically change the options of a drop down list depending on the values of other drop down lists. The problem I am getting is that in internet explorer ( with Windows XP sp 2) my script is blocked by default.An information bar says that...

I am in the process of converting a form which uses the post method to one which uses the get method The current form reads <cfform name="qSearch" method="post" action="index.cfm?page=cresults#session.amper##session.URLTOKEN#"> My question is, is there any way of using the "get" method but...

I came across a site recently which had 2 yes / no radio buttons where you had to click whether you were a member or not. If you clicked yes, then the form changed to elements where you could input login info. If you clicked no, the form changed to include a completely new form containing...

I have a query which I am calling with <CFInvoke>. I am passing this query about 12 parameters ( a mixture of numbers and strings) The numbers range from 0 to 10000 and the strings are generally 1 word but one string could be up to 10 words I have placed these paramameters inside a session...

Is it ok to introduce a variable in a page as follows <cfparam name="somevar" default="1"> And then update its value with links somepage.cfm?somevar=20 etc I have seen this quite a lot recently and I'm not sure if it is good practice. Should somevar be explicitly scoped ? <cfparam...

Ive found a problem with Coldfusion and SQL Server 2005 I utilised a .sql script to create tables IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CLSFD_AdBlocks]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[CLSFD_AdBlocks]( [BlockID] [bigint] IDENTITY(1,1) NOT...

Is it possible to generate a .sql script in the sql server 2000 format using sql server 2005 I would like to generate a script in this format using 2005 if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CLSFD_AdBlocks]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop...

I've come across a problem with SQL Server 2005.When I make changes to my table design, I tend to adjust the .aql file myself and re-execute it. (Maybe this is not a good idea?) I have found that when I re-execute the script in SQL Server 2005 Developer edition then I get the following error...

I've been playing around with changing the number of rows returned using SELECT TOP 10 FirstName, LastName, BirthDate FROM Persons ORDER BY LastName, FirstName Is it possible to amend the code so that it returns rows 30 to 40 for example?

Using the following code to try to order my results but it's flagging an error. What's the correct way ? ORDER BY CASE @SortBy WHEN 'ItemPhoto' THEN ItemPhoto END CASE @SortDirection WHEN 'desc' THEN DESC...

I am currently storing dates in my database as char(10) I am using coldfusion to enter values formatted as follows : DateFormat(ExpiryDate,"yyyy-mm-dd") In my stored procedure , I want to compare the date to now in order to filter a query. I am trying WHERE DATEDIFF(day, ExpiryDate...

Am I right in thinking that if the first expression in an or statement evaluates to true then the second part is not tested For example if(a = 10 or b = 20) Print 'Message' Here, if a = 10 then Message is printed without evaluating b

InIn order to convert a coldfusion query to a stored procedure I've implemented the following code given to me in an earlier post. SELECT Column1 From Table WHERE Column2 = 0 <cfif someVar = 3> AND Column3=0 </cfif> becomes.......... SELECT Column1 From Table WHERE Column2 = 0...

I'm cycling through a list using the code below. Is there any way to improve this code or is this the most efficient way? DECLARE @list varchar(30); DECLARE @element varchar(30); DECLARE @d char(1); DECLARE @x INT; SET @d = ','; SET @list = 'hello,world,out,there'; SET @list = @list + @d...

Hello I'm converting a coldfusion query to a stored procedure The Coldfusion query runs something like this: SELECT Column1 WHERE Column2 = 0 <cfif someVar = 3> AND Column3=0 </cfif> How can I achieve the selective inclusion of AND clauses in TSQL ?

I read in one of the livedocs that cfmodule is to be avoided. Under Performance donts the article reads Don't use cfmodule It's slower than a CFC method invocation, it's slower and uglier than using a custom tag with a prefix, it's even slightly slower than a regular custom tag invocation...

Hello I'm trying to convert milliseconds into seconds to 2 decimal places For example 147 milliseconds to become 0.15 seconds I'm using NumberFormat but it's not working out How can I achieve this efficiently?

Is it possible to use a variable in a <cfoutput query => expression For example <cfset myVar="colID"> <cfoutput query = "someQuery"....> Value in first column is #someQuery[myVar]# </cfoutput> Tha above does not work. Also tried someQuery[variables.colID] That doesn't work either ! So is...

Need help with dreamweaver regular expressions as part of the find and replace function. I'm trying to work out 1 Dreamweaver MX regular expression to convert the following. WHERE CategoryID = #Val(ARGUMENTS.CategoryID)# or WHERE AdID = #Val(ARGUMENTS.AdID)# To......... WHERE CategoryID =...