Search results for query: *

Im trying to simplify my code on a form. I have a series of command buttons, each of which go to different forms. I want to write code to check which button was last clicked and based on that value, go to a certain form. I guess I would use a Select Case statement? I would also like to pass...

Does CR come with ColdFusion 4.0 or 4.5? I have the CF book that says that it is available but am having trouble getting started using it. Any help would be greatly appreciated!

I have read that CR comes bundled with CF 4.0 (or 4.5 upgrade)....if so, how do you access it? Thanks!!

Can you use ActiveReports with ColdFusion like you can VisualBasic?

Thanks Kevin. I have that field already and it is printing fine at the top of the first page, but, the concern I have is that most of the time, these documents are multiple pages, containing information from different departments. If Dept A wants to print the document (and I use that term...

Normally, when something is printed from the web, it displays the current date at the bottom right hand side of the page. The document that I want to print is dynamically generated based on weekly entries input by users and is always more than one page. A new document is created for each week...

Thanks! That was exactly what I was looking for!!

That is how I did it too. That is why I don't understand why I am having so many problems. Thanks though!

GJ, Thanks...I will need to loop through the query then to to assign to a variable the salary amount now and output them later. <cfset num = 1> <cfloop> <cfoutput query=&quot;get_data&quot;> <cfset salary = &quot;cri&quot; & #num#> <cfset num = num+1> </cfloop> Or should this be a for...

I have 2000 and 97 on the same machine and am experiencing problems. I have consulted the knowledge base search for help but can't quite get the answer that I need. If I create a new db using 2000, everytime I try to save, open a report in design view, etc it takes forever!! Also, when I try...

Yes, but the result set will be much larger than that. For example, there will be X Y Salary Illinois Chicago 30,000 Illinois Rockford 25,000 Illinois Decatur 18,000 Ohio Dayton 32,000 Ohio Colombus 29,000 Ohio...

Thanks for the correction Tom!

I had this happen quite a bit to me too. It usually happened on a date field in my situation. There was an extra space in the beginning or an extra 0 on the end or something similar. I changed the datatype to nvarchar or something like that and it worked fine then. That just requires some...

I am a little new at CF so bear with me... I have a query name get_totals as 'Select x, y, sum(salary) as salary from table group by x, y (There will only be three instances of y and 10 instances of x ever!)' I need to then assign variables to parts of the results of this query. For example...

I am trying to connect to an Oracle DB by using a linked server in SQL 7. Often I will get errors like ORA:03113 end-of-comunication file or even SQLConnectAttr failed. These are seperate instances of errors but they seem to be happening more often. Im not really sure why or what is causing...

I am executing a stored procedure that accessess a linked oracle server and should populate an existing table in a SQL database. Sometimes I get an error ORA-03113: end-of-file on communication channel when I run the sp or even when I click on the server name in Enterprise Manager. I'm not very...

Thanks keith....I figured it out and it was #4 on your list! Too bad I didn't look here after you posted! :-)

I am using SQL's OPENQUERY to an Oracle server. This is a little of what I am using SELECT * FROM OPENQUERY(OracleSrv, 'Select A, B, C FROM D where A = &quot;something&quot;'). I keep getting an invalid column name error when I do this. I can run this is Access and it works fine. Am I using...

I am having the same problem. I have asked quite a few people and haven't gotten any good answers. Some have said that it is probably my log files but those are actually located in another partition and directory as to where these sql.log files are. Ill post here if I find out first! Thanks!!

You should be able to use SUBSTRING(BRANCH, [STARTING POSITION], [ENDING POSITION]) SUBSTRING(REGISTERNUMBER, [STARTING POSITION], [ENDING POSITION] I guess it depends on what you are extracting the data for. tgriffin