Search results for query: *

I have two select lists in my form. The first will have values in it based on results from a SQL stored proc. The second one will as well, but I only want to show those items in the second select list based on the value chosen in the first. I hope I have explained myself well enough. How can...

Excuse my lack of knowledge, but I am trying to figure out a way to do this and am not getting anywhere. I have group of radio buttons, one for each month of the year and when the page initially loads I would like it to automatically check the radio button for the current month. How can I...

I've read dozens of posts on how to show and hide table rows, text fields, etc. What I could not find is if it is possible to show and hide a group of table columns. Would this even be possible? Tim

Hello, I am working a table of categories which includes an interger column containing the totals seconds for that category. I am trying to convert the seconds to hour/minutes/seconds, but am getting strange results. It's been a long week, but, why do these two statements output such different...

It's been a while since I used foxpro. I need the syntax for doing case statements in a select. Ie. in sql server it's select case when state='al' then 'alabama' end from table so what is the syntax dto do this in foxpro, or can you not use case in a select? Tim

Is it possible to use DTS and insert a text file into a table that has more columns than the text file? Or is it easier to just dump the file into a dummy table and then insert into the live table? Tim

I have a cold fusion program that has a couple of calls to SQL. One is to add data the other is to add/modify. Both calls pass a "comments" variable from a form field. The add program may pass a comment like "it's a test". When this gets passed to SQL it goes through fine. If I use the same...

I am trying to do a join which will summarize the number of times each employee has met with a supervisor. I also want to show those supervisors who have not met with a particular employee as having counts of 0. Something like this: emp supr bob frank bob jim bob frank fern...

I'm not even sure how to describe what I am looking for but here goes... I have a CF search app which has an option at the bottom to open up a csv of the results in a new window if the option is chosen, or if it is not chosen the results are displayed by calling another page. What the bigwigs...

I have looked around other sites and can't find an example closely match ing mine. I have a cold fusion program that gets variables passed to it from a CGI page. I prefix these form variables with "form.variable" for scoping. This page then eventually leads to a submission page with URL links on...

Since the search function is down I'll ask the question. I have a form which when submitted will automatically print the form. What I am wanting to do is have an alert come up after printing to say that the form was successfully submitted. However, this may pop up before the print prompt does...

I have a form that when clicked on shows the same form but with links at the bottom hidden, and a print prompt automatically comes up to print the form. This part I have done and works fine. I would like to show the links at the bottom after the document is printed so the user isn't stuck on the...

I am trying to get java to see that a radio button is checked but it doesn't "see" it. It is a Cold Fusion app and there are a set of three buttons all with the same name but different values. When a radio button is selected and the form is submitted it is supposed to load the same page again...

I looked but could not find an existing thread which matches my problem. Basically I have a filtering app that has many variables passed to a stored proc. Some of the variables passed are actual arithmetic operators, =, >=, <= and so on. Currently I have conditions in my where clause of my...

Is it possible for a DTS package to read a text file from a Unix server? Right now I am reading it in from a windows directory. thanks, Tim

I have three packages that I am currently running at 5:00 AM. If I want to schedule these to run at 3:00 AM instead and schedule them to do so, will that overwrite the original schedule or will it execute at 3:00 AM and again at 5:00 AM? If the latter, is it possible to "reset" the packages or...

I have an interesting problem that I have an answer to but it takes 30 seconds to run. I have a table with records in it something like: empid queue itemnum 1234 att 0913403 2356 comp 0913430 1234 comp 0913430.... I also have a table with all possible queue's in...

I have set up a DTS package which when executed through enterprise manager works fine. When I try and run it in QA I get the follwoing errors: output DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSDataPumpTask_1...

I have a txt file where each valuein each line is separated by commas. I am trying to load this into an already created sql table using <cfstoredproc> and each value separated by a comma represents a field in the table. I have been trying to use an array to load in each line and send it to the...

I am using a js calendar. This calendar is used in dozens of applications on our internal website. On this one application, every once and a while the calendar will be clicked on and an error will come up: parent."pagename".document.open is not null. This application is developed with Cold...