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...

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 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...

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...

I am trying to embed a dynamic hyperlink that will take a value from the IWR (WorkOrderNumber) and pass it as a variable to a hyperlink. Based on Cognos' Knowledge Base, I should have a calculated field with something like (assuming that this whole thing is a Value/String) If...

This may be more of a OS questions, but here goes. My Cognos System & batch files are located on Server1\d$\program files\cognos\cer3\bin My Cubes and macros are located on the same server under Server1\justbecause\app\areas I am trying to launch the script below from SQL Server which is on...

Does anyone know of an add-in that will work with MS Query Analyzer and print in color? It makes it a lot easier to read and spot keywords, etc. There is one software (Star Print) I used with MS Access and I know works with VB, but it does not have a MS SQL Server SQL piece. The SQL Server...

I need to update a MS SQL Server Table with data from MS Access. In SQL Server it would look something like: Update Master Set Reported to 'Yes' From Master Left Join (Select Distinct UIC, DateReported from NMC_Detail Inner Join CurrentInfo On CurrentInfo.ReportDate = NMC_Detail.DateReported)...

I want to update multiple fields off a single Case (or IF) statement. Example Update Temp_AMSS If DIC <> 'XM' begin Set Errors = 'Wrong Report' Set RejectErrors = RejectErrors + 1 end end If next query Begin Set Errors = Errors + ' next Error' Set...

MS Access has a function called FIRST, which returns the first iteration of a result and looks like SELECT Master.Part_No, First(Master.Part_Name) AS Part_Name Group by Master.Part_No I need to try the same thing. I am pulling repair parts lists from several maintenance shops, I have a...

I need to update a field (True_Poss) to reflect the number of days from the 15th of last month to the date in the field called (Dte_Reported). Here is what I am trying, but I get an Incorrect syntax near '=' error. I have tried variations of Set tablename.true_poss, etc. same results. Any...

I can't remember the select command that will list all tables and their structure (fields). When I pull them into text with headers on, some of the field names concantenate. Thanks Larry