Webmaster Forum / ColdFusion / Advanced Techniques / January 2005

Trying to eliminate people adding garbage to popular searches...  <cfif term
does not contain 'porn'> Do what I need to do... </cfif>  I know the cfif term
contains 'this value' it works... But can't seem to get the does not contain
working...  Probably an easy fix...

Hi There,  I'm trying to pass cf variables from a database to a javascript
pop-up window. Does anyone know how this can be done?  Trying to pass variable
spot_ID, but it's not getting passed through to the pop-up window? Please help

Hello THis is the stored procedures I write  CREATE Procedure insertUser
@BuyerName  int, @BuyerPhoneNum  varchar(50), @Note ntext, @UserID int,
@PropertyID int, @DealTypeID int, @DealDate datetime   AS  Declare @DealID int  
INSERT into Deal(BuyerName,BuyerPhoneNum,Note,userID ...

Hi,  I have an application with login page.Users should enter their credentials
before accessing the system. By default the session timeout for the user is set
to 20 minutes by the admin. I would like to customize this time limit for each
user. That means the number of minutes ...

I'm parsing an XML document and checking to see if a specific node exists
using StructKeyExists.  That part works fine, but it's when I'm dealing with
missing attributes that I stumble.  I'm using this to check for the element:
<cfif StructKeyExists(MyXML.company.team[1] ...

Confirm that all links are available and working.  I would like to check using
our local host and for the web site, that all refered to links are properly
connected and working.   Can we receive any suggested software to preform this
link validation. Thank you!

Hi, I have a form that feeds into a page with cfstoredproc. All fields besides
the primary and foreign keys are varchars. In spite of that I get an error
saying: ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Error ...

I have a MSAccess db with lots of fields - the pertinent ones are StoryID
(auto-incrementing number), Paragraph1 and Title - with Story needing to be
dynamic?
I am using a dreamweaver table with a Repeat Region server behavior that goes

I have a form that I am trying to dynamically add a text field if a user
clicks on an add button. I would also like the rest of the form to still hold
onto the informaton already input into other fields. I of course would have a
submit button on the button of the form that would ...

Hi, I'm having a problem figuring out how to make this work. ( see attached
code ).. I had it working at like 1 nested subquery... but anything after  ( 2
nested levels ) that I get 'You have written a subquery that can return more
than one field without using the EXISTS reserved ...

i recently inherited cold*fusion code with a bracket notation (where either the
column names or the column values from a database are read into the variable)
and then the program will have a cfloop that goes through this variable and
seems to pull out the individual column ...

I tried to post this earlier, but it seems to be lost or invisible to me or
something of that nature. If for some reason it pops up twice, I sincerely
apologize.
Question: Which processes faster,  nested loop queries or output queries

I see two items neither pertain.
I have a table in Oracle
  ASSIGNEDHOSTID                  NOT NULL RAW(4)
 PARENTID                                  NOT NULL RAW(4)

I have created a form where the field names are generated dynamically.by a
loop.  The project I am working allows students to order their college
transcripts and have them mailed to their selected destinations.  They can
choose as many destinations as they want (for example, say ...

I have created a form which allows the user to input data about a file as well
as the file itself (using input type='file').  This is all good and works fine.
My action page creates the proper directories (if not created already), and
uploads the file properly.  It also updates ...