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 strongm 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: *

  • Users: Dimitrie1
  • Content: Threads
  • Order by date
  1. Dimitrie1

    string parameters in command

    I have a string parameter called PlaceName this works for single value p.Name = '{?PlaceName}' but I want a multi select and this is erroring AND p.Name IN '{?PlaceName}' I've also tried AND p.Name IN ('{?PlaceName}') and it errors too help please Linda
  2. Dimitrie1

    ANSI SQL 2012 . Is INNER required

    I've been told I need to bring all my SQL code up to ANSI standard before we move to SQL 2012. Currently most of my joins are defined in a JOIN statement and not the WHERE clause. my question is can I just say TABLE1 JOIN TABLE2 ON .... or must I say TABLE1 INNER JOIN...
  3. Dimitrie1

    Tax Updates - using incorrect version

    We are in the process on upgrading our HRMS system to 9.1 from 8.9 but running into problems so the project is taking much longer than expected. Oracle has said they will stop creating 8.9 tax updates soon and therefore we want to start using the 9.1 tax updates on our 9.1 client. My...
  4. Dimitrie1

    Payroll Tax Updates

    I'm a very newbie PeopleSoft programmer and need to find the Update Plan for Tax Updates. I searched but no luck
  5. Dimitrie1

    derived fields

    A user enters their report format into a derived field. In my SQR I'm trying to determine what they picked but the SQR does not recognize the table name - can I not use derived fields in SQR? My real problem is that the PDF version of the report prints a quarter inch to the left and prints on...
  6. Dimitrie1

    hashing

    I have a table full of registrations and more are inserted daily. I need to hash the current passwords and the new coming in. I'd like to use the SQL hashbytes function to hash the current records but don't know how to hash the new records thru vb.net I've seen a few methods in vb.net but...
  7. Dimitrie1

    importing external data

    I need to import external data - daily for about 6 months. I'd like to automate this process. I've tried bulk insert, openqueryrow, ssis --- nothing is working - any ideas.
  8. Dimitrie1

    BULK INSERT 0 rows affected

    I have a csv file and am trying to insert it into a table it doesn't error it just says 0 rows affected. I am signed on to SQL with SQL Authentication BULK INSERT database.dbo.table FROM '\\Studebaker\itpmdocs\Business_Proc\Cheque\Test_Subsequent.csv' with ( firstrow = 2, fieldterminator...
  9. Dimitrie1

    Query results in ANSI

    I need to store the results of a query in a fixed length ANSI text file. I'm using SQL2005. Any ideas ? I know I can do a SaveAs on the file but I need to run this daily for 6 months and am trying to automate as much as possible.
  10. Dimitrie1

    ASCII Fixed File

    I need to create an ascii fixed length file I've managed to create the file but am told that it is unicode and they need ascii. How do I get sQL2005 to use the ascii character set
  11. Dimitrie1

    SSIS Flat File Question

    I am trying to create a package to take a table and make a flat file - it works great except I can't set the row and column delimiters so all the records are on the first line please help
  12. Dimitrie1

    MyCallPilot - webversion

    I can get my voicemail via my phone. I can use callpilot desktop messaging through Outlook. But if I try to connect to call pilot via the web interface it tells me 'invalid credentials'. I can signon from another person's computer but nobody can signon from my computer. I'm running...
  13. Dimitrie1

    sql 2005 and SourceSafeq

    I am trying to create a sourcesafe database for my sql2005 stored procs. From what I found you need to set it up on the server using Visual Studio but the instructions I found are for VS.NET version 6 and we have version 8 --- any help please
  14. Dimitrie1

    autosubmit hidden form

    how can I change this code for it to automatically submit. System.Web.HttpContext.Current.Response.Write("<html><body><form method=""post"" action=""http://159.18.103.228/unpservice/UNPPaymentService""><input type=""hidden"" name=""paymentRequest"" value=""")...
  15. Dimitrie1

    Error List

    I closed my error list and I can't get it back. I used the menu and the short cut keys. I have errors but it won't display.
  16. Dimitrie1

    Findcontrol with a datalist

    I know this has been written about but I still can't make it work - please help. I have a datalist with fees, the last row being the total. 2 labels per row. All I want is the 2nd label of the last line. In the itemdatabound event i've coded Dim xx As String =...
  17. Dimitrie1

    create/post xml

    I'm an XML newbie and a novice at vb.net When a button is clicked on my vb app I need to generate an XML file and post it to a secure web site. any ideas where I can start with this.
  18. Dimitrie1

    Open New Form and Pass a Parm

    I am in form 'propertyquery.aspx. and want to click a button which will open form 'more_info.aspx' and pass a parameter. this should be easy but I don't know how to do it.
  19. Dimitrie1

    Inserting data with Linked Servers

    I have an asp.net app and am calling stored procedures. My app worked great until I had to use linked servers. I did some research and learned that yes performance is impacted and specially on inserts. i read about openquery but can't figure out how to use openquery with my current sql...
  20. Dimitrie1

    Image Button and Tool Tip

    I have an image button that works great but does not show my tool tip text that I sent in the properties on setup. any ideas. it's a .jpg file

Part and Inventory Search

Back
Top