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!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. tgriffin

    which button was clicked?

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

    Crystal Reports and ColdFusion

    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!
  3. tgriffin

    CF and Crystal Reports

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

    ActiveReports with CF

    Can you use ActiveReports with ColdFusion like you can VisualBasic?
  5. tgriffin

    print page

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

    print page

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

    query/variable question

    Thanks! That was exactly what I was looking for!!
  8. tgriffin

    Access 2000 and 97 on same machine

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

    query/variable question

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

    Access 2000 and 97 on same machine

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

    query/variable question

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

    What is the SQL equivalent of this Oracle code?

    Thanks for the correction Tom!
  13. tgriffin

    Import table from Access to SQL

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

    query/variable question

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

    Error using Linked Server

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

    Error when connecting to Oracle Linked Server

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

    Correct use of single and double quotes

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

    Correct use of single and double quotes

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

    Hard drive filling up!

    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!!
  20. tgriffin

    What is the SQL equivalent of this Oracle code?

    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

Part and Inventory Search

Back
Top