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

    Import a PDF into a Crystal Report

    Thanks, that's what I figured, but was worth a shot Thanks
  2. raynkel

    Import a PDF into a Crystal Report

    My Version is Crystal 9.2 The PDF is in a folder on the webserver where the applicaton that uses the crystal reports is located. The application knows the PDF exists by a bit field in the database. The PDF is named to relate to the record it belongs to. I currently use a process to create the...
  3. raynkel

    Import a PDF into a Crystal Report

    I have a report that shows SQL data as a report. We have PDFs that are associated with each record. Is there a way to bring the PDF into the report as an additional page to the report? I am very limited in crystal reports so any solution would need to be explained well. Thanks in advance.
  4. raynkel

    SQL Query quandry

    No doubt. I see that now. I was having a really bad day yesterday. Sorry about that!!
  5. raynkel

    SQL Query quandry

    I am using an SQL database to track parking. I am trying to write a query to get data. Should be simple, but of course it's not. The problem is: There are 3 ways to refer to a parking stall. StallNumber, PermitNumber, and CardNumber. Problem is, not all records have all three fields. Record 1...
  6. raynkel

    Using Query stored in database

    --This works SET ANSI_NULLS ON SET ANSI_WARNINGS OFF go CREATE PROCEDURE [dbo].[sp_GetQueryResults] @ReportNumber int as DECLARE @String varchar(8000) SET @string = (SELECT QueryString FROM ReportQuerys where reportid = @ReportNumber) exec (@string) GO
  7. raynkel

    Using Query stored in database

    I am not sure how to set it up to do it. How do I run a QueryString that is stored as a record?
  8. raynkel

    Using Query stored in database

    I store a query String..ie(Select * From Project, etc) in a database as a record. I want to call that query string and run it. I will send it the Record number and need to get back the results of the querystring that is in the database. I could just do one call to get the string and then use...
  9. raynkel

    Cookie crumbles!

    Sorry, thats way above my knowledge level.I am just throwing the Table tags in to a DB and calling it on the next page. Thanks Much though
  10. raynkel

    Cookie crumbles!

    When I used your code : s="%3Ctable%3E%3Ctr%3E%3Ctd%3EProjectName" t=unescape(s) wscript.echo s & vbcrlf & t I got an error abour the wscript I used just the: t=unescape(s) and it stripped oout my tags
  11. raynkel

    Cookie crumbles!

    Thanks for all the help everyone. I tried using the unescape, but it stripped out my <> tags leaving only table and tr showing. I may just save it to a SQL table and call it on the next page. How would you guys do it? This is bascially a report generator. The user selects fields from the...
  12. raynkel

    Cookie crumbles!

    PHV, thanks you so much. I actually used MyString = Request.Cookies("objTable") ReplacedText=Replace(MyString,"%3E",">") REReplacedText=Replace(ReplacedText,"%3C","<") REREReplacedText=Replace(REReplacedText,"%2","") For some reason the %2 showed up and I had to get rid of it too. Thanks...
  13. raynkel

    Cookie crumbles!

    I have an application that builds a Query string on the fly. I send this string to a function that builds a table on the fly from the data the Query returns. The Table string, ie..(table><tr><td>Stuff</td></tr></table>) is way too long to send in a querystring. So I have sent it to a cookie that...
  14. raynkel

    Bulk Update (change) of SQL Database Column value

    I used this and it worked like a dream. Thanks so much! UPDATE dbo.tbl_AnnualInventoryCounts SET dbo.tbl_AnnualInventoryCounts.WareHouseId = '99' WHERE dbo.tbl_AnnualInventoryCounts.WareHouseId = '32';
  15. raynkel

    Bulk Update (change) of SQL Database Column value

    I could use some help and I am completely clueless on this. I am hoping someone can(will)help. I have a table with 9 fields: UserID Year CountNo ItemID WarehouseID ProgramID Quantity ModifiedDate Location The Field WarehouseID has a value of 32. I need to change ALL of the records from 32 to...
  16. raynkel

    I am using the following code to de

    Thanks very much. I searched forever trying to find that. It works like a charm. Ray
  17. raynkel

    I am using the following code to de

    I am using the following code to delete a row in a datagrid. Private Sub DataGrid1_DeleteCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid1.DeleteCommand Dim Index As Integer Index = e.Item.ItemIndex...
  18. raynkel

    delete

    Private Sub DataGrid1_DeleteCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid1.DeleteCommand Dim index As Integer index = e.Item.ItemIndex YourDataSet.YourDatabase.Rows(index).Delete()...
  19. raynkel

    Background Image

    Thanks ,but another priority came up, this problem will have to wait. My new problem is trying to print labels. I want to be able to print a variable number of labels depending on the number of items in the inventory. ie.. if I have 5 computers I need 5 labels for them. If I have 2 monitors I...
  20. raynkel

    Background Image

    That seems to be working, but not in the manner I had hoped. It works if the Invoice goes on to more than one page ie.. if the one invoice takes two pages, but if I print two copies of the same invoice, It puts the same image on the first page of both copies of the invoice. That is where I am...

Part and Inventory Search

Back
Top