Recent content by erwino

can you use: parent.CreateCustTbl.location.href=""; OR parent.CreateCustTbl.location.reload(true); to force the page to change when you click the link/ do something. Erwin Oosterhoorn Analyst Programmer, ice hockey player/fan.

Have you tried to insert data directly into the database using the SQL statement but with values entered where the form values are? If this works, check the form to see where the info is going. Erwin Oosterhoorn Analyst Programmer, ice hockey player/fan.

I think I do, and let me know if this works or what is not working. select * from LOG where (select linkedLog from LOG where lognumber = '#url.ref#') = LOG.lognumber AND lognumber != '#url.ref#' or (select linkedLog from LOG where lognumber = '#url.ref#') = LOG.linkedLog AND lognumber !=...

I can't follow the example completely but why does the query select * from log where lognumber = #url.ref# or linkedlog = #url.ref# not work? IS it the ' in your sql script? You are refering to numbers I suppose, so you don't want to look for strings. Let me know if this is the solution ;-)...

You can't get javascript to set coldfusion var. because the coldfusion part/code is run before the html page is created and send to the browser. If you want to get interaction you have to submit the page with the values. Erwin Oosterhoorn Analyst Programmer, ice hockey player/fan.

assign the list of emails to a second list, check the second list using ListFind(list, value[,delimiters]) to check if the email is already in the (second) list, if not, add. Erwin Oosterhoorn Analyst Programmer, ice hockey player/fan.

Create a 'disitinct' query. enter the catagories in a list and add to list if the new item is not already in the list, display list. There are several options available, it depends on what you have available and the access to the data. Erwin Oosterhoorn Analyst Programmer, ice hockey player/fan.

OK, here is an example for splitting the string: <code> <cfset i_max_string = 50><!--- max length of string ---> <cfset s_file_name =...

len(string) Erwin Oosterhoorn Analyst Programmer, ice hockey player/fan.

this problem is because it's one long string of characters, and the browser can't split the text anywhere. You need to do something to force a break in the text. Maybe search through the string and replace the '/' with '/ ' so text can be wrapped in the cell. Erwin Oosterhoorn Analyst...

try this: <code> <table border=&quot;0&quot; width=&quot;100%&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot;> <TR vAlign=&quot;top&quot;> <th vAlign=&quot;bottom&quot; width=&quot;20%&quot; bgColor=&quot;#444444&quot; class=&quot;arttext&quot;> <font...

To take of the header and footer you need to disable that in the browser, you can't disable that part from a webpage in a simple way. This means that anyone printing the letter needs to turn off or blank out the header and footer settings in the printing setup of the browser. Erwin Oosterhoorn...

there are a few errors in the tags, try this: <code> <cfprocresult name = &quot;RS1&quot;> <cfprocparam type = &quot;IN&quot; CFSQLType = &quot;CF_SQL_VARCHAR&quot; value = &quot;GH45632&quot; dbVarName = &quot;@param1&quot;> <cfprocparam type = &quot;IN&quot; CFSQLType =...

the Application.cfm file (remember the capitalisation) includes on all files you create under that site. So if you have a check in that page all pages will include the check. If you create a session variable that each user has at the start of the session, you only have to check for that variable...

Can you use the group function? order the data by the date and output the query using the group by date. This should give you an output of each date where you can display all information/create your graph. (maybe? ;-) Erwin Oosterhoorn Analyst Programmer, ice hockey player/fan.