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!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Problem refreshing the page containing 2 frames ...
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. -
INSERT INTO question
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. -
sql select statement help..
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 !=... -
sql select statement help..
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 ;-)... -
Javascript function within Cold Fusion
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. -
sorting list and getting unique items
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. -
Database probelm
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. -
help with table tr and td, please help!
OK, here is an example for splitting the string: <code> <cfset i_max_string = 50><!--- max length of string ---> <cfset s_file_name =... -
help with table tr and td, please help!
len(string) Erwin Oosterhoorn Analyst Programmer, ice hockey player/fan. -
help with table tr and td, please help!
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... -
help with table tr and td, please help!
try this: <code> <table border="0" width="100%" cellpadding="0" cellspacing="0"> <TR vAlign="top"> <th vAlign="bottom" width="20%" bgColor="#444444" class="arttext"> <font... -
Printing w/o borders and footers
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...- erwino
- Post #4
- Forum: Javascript
-
Stored Procedures
there are a few errors in the tags, try this: <code> <cfprocresult name = "RS1"> <cfprocparam type = "IN" CFSQLType = "CF_SQL_VARCHAR" value = "GH45632" dbVarName = "@param1"> <cfprocparam type = "IN" CFSQLType =... -
Default Page for Session Timeout
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... -
Creating charts of oracle data
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. -
Default Page for Session Timeout
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... -
Array Problem
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... -
Array Problem
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... -
Is it Possible to combine these queries?
(: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... -
Erwino - tlHawkins - Pls Help - One more time
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...
