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!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ice7899
  • Content: Threads
  • Order by date
  1. ice7899

    Existence of a session variable to check login

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

    Script Blocking

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

    Converting post to get with URLTOKEN

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

    Dynamic Forms with Javascirpt

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

    Use of Session Variables

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

    cfparam best practice

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

    Coldfusion and SQL Server 2005

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

    generating .aql scripts in sql server 2005

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

    Coldfusion and SQL Server Developer 2005

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

    Alternative to TOP

    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?
  11. ice7899

    Order By Variable

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

    Help WIth Dates

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

    SQL OR

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

    Extrmemly Complicated Stored Procedure Problem

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

    Using Lists

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

    Selective Inclusion of SQL commands - Coldfusion conversion question

    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 ?
  17. ice7899

    cfmodule performance

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

    Number Format

    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?
  19. ice7899

    Advanced Variables

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

    Dreamweaver Regular Expressions

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

Part and Inventory Search

Back
Top