Search results for query: *

I have a spreadsheet that after much consternation turns out to actually be an XML, not an XLS which the current extension is. There are over 25 fields, what is the best way to bulk insert it?

I have a CF form which requires the user to select a site location for each record, to speed up the processor, I put the most likely answers (1-4) into the drop down. The last item in the list is "More Options". I want an onclick event here that will populate the drop-down with all 152...

I have a form which requires the user to select a site location for each record, to speed up the processor, I put the most likely answers (1-4) into the drop down. The last item in the list is "More Options". I want an onclick event here that will populate the drop-down with all 152 choices...

Does anyone know how to display a MS OLAP Cube within ColdFusion with the drag & drop capability? Or call MS Analysis Services from within Coldfusion? We want to merge the technologies. Thanks,

Does anyone know how to display a MS OLAP Cube within ColdFusion with the drag & drop capability? Or call MS Analysis Services from within Coldfusion? We want to merge the technologies. Thanks,

Is it possible to specify what file types are visible when using Input Type="File". Like most designers, I try to make things as idiot proof as possible. In this case, I only want *.dat files. I have another application that needs only Excel files. Thanks, Larry

Has anyone tried creating stacked bar charts such that the X-Axis is a timeline (last 12 months), the y-axis is numeric (number of parts) but each bar represents a different entity (store)? Simply put, I want 1 chart, each month would contain 2 or 3 stacked bars. The stacked sections are types...

When using the upload command, the file gets written to the server , but changes the associated filedate to the date and time of the upload. i.e. The filedate on the CD is 6/17/05; if I upload the file to the server today, the filedate on the server will be 7/27/05.

Thanks, that solved part of it. It is picky as to which server I load to but I can get around that. Is there a way to maintain the files original filedate?

Not really, I do not believe it is the code part but what Domain User permissions ColdFusion operates under. I have a code that uses the browser to populate Actual_Spreadsheet_Name and it is passing it, but can not find it unless I Share that drive/folder to everyone. In this case, it I am...

I want a user in Cold Fusion to be able to use the browser to point to a drive\file on their local machine (hard, floppy or CD) to upload the file to the server. I keep getting Path not found error unless I "Share" the directory to "Everyone". It is picking up the correct path and filename but...

My apologies, wrong forum. CPT Tom

I want a user in Cold Fusion to be able to use the browser to point to a drive\file on their local machine (hard, floppy or CD) to upload the file to the server. I keep getting Path not found error unless I "Share" the directory to "Everyone". It is picking up the correct path and filename but...

I have a proc that runs just fine as a proc when run manually, but breaks part way through when run as a job. The proc drops the existing table recreates it from a trusted server. This runs a "Select * Into table FROM OpenQuery (Servename, 'Select * From owner.table'). The error message is...

Try something like this DECLARE @Thought1 VARCHAR(Size) DECLARE @Thought2 VARCHAR(Size) SET @Thought1 = Yourfield SET @Thought2 = Yourfield PRINT ' The result is ' + @thought1 + @thought2

Assuming that your date field is called LastUpdated you could write: Select * Where DATEDIFF(D, LastUPDate, GETDATE()) <= DAY(GETDATE()-1) This calls the DATEDIFF (Date Difference) Function states that you are calculating by (D, Days) LastUpdate is the oldest date GetDate() is today and that...

I need to assign quantities from Table_A based on Priorities in table_B when Table_B has multiple Priorities. Table_B has a required quantity based on priority and may have more than 1 priority but not more than 3 priorities. Here is how I am trying to work it. DECLARE @Cat_Count INT...

Has anyone ever tried to create a method to drill from PowerPlay Cube to a 3rd Party Report like Cold Fusion? I know it is possible to put a hyperlink in IWR to direct to a 3rd party and pass variables. Might it be possible to pass the variables to IWR and have it bounce directly to a 3rd...

Here is how we solved the problem. We created 2 catalog calculations at the folder level. The first one was the begin tag ['<html><a href = "Ourserver/website/DWH_WO_Detail.cfm?WO='] The second was the end tag ['"Name</a>'] We then went to the IMR and made the field If (xxxx) then (BeginTag...

Cognos' Knowledge Base has 2 examples and both have </a> at the end. I tried your idea and it still did not work.