Search results for query: *

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.

You can create a file that you include in every page (by using Application.cfm) to check for a live session. If the session var is timed out, redirect to a page to tell the user this. You can also redirect the user to a warning page after the time has expired by using the redirect in the header...

Carl, that's exactly what I had in mind. Just make sure that there are no comma's in your values, what shouldn't be if they are filenames. Beejay, if you need a hand with some of the code let us know, remember that if you want to use javascript and Cold Fusion the CF code is run before the page...

Can you not use the return value of the checkboxes directly and use the list function to extract the filenames, loop over the list and delete the filenames in the list. Am I missing the boat completely? Post some code if this doesn't make sense. Erwin Oosterhoorn Analyst Programmer, ice hockey...

(:I You should change the setup of that table to create a table with error descriptions: vender_issue should store the id of the error description table ie error_id = 1, error_desc = 'Shipped to wrong location', error_id = 2, error_desc = 'Received item late' etc then you can create a query that...

What is the value of #Select2_Default#? When does this change? It looks like you are assigning the var sel2def to this and then never update this when you make a selection. If you create this variable as an input variable you can send the selected option to be used as selected Index. example...