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 Rhinorhino 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: sdh
  • Content: Threads
  • Order by date
  1. sdh

    PHP to sort order of database records

    I am writing a CMS system I have been puzzling over this for a few days and not getting anywhere. I have a table which has a column content_order this holds an integer which dictates the order of paticular content articles. I have an interface which lists the articles I want to add...
    • sdh
    • Thread
    • Replies: 4
    • Forum: PHP
  2. sdh

    Best approach dbowner

    I have a database which is to be replicated, I connect to this db from ASP using integrated security (therefore have IUSR_etc for each machine as logins) Currently the dbowner is sa is this my best approach as this user should be on all replicated machines? Thanks for any advice SDH
  3. sdh

    Urgent help-IDentity column

    on a replicated db this has started to return NULL for scope_identity any ideas why? INSERT INTO "dbtophorse"."dbo"."tbOrder"("tbOrd_total","tbOrd_datetime","tbUsr_id","tbshipingID") VALUES(@orderTotal,GETDATE() ,@User,@tbshippingId) SET @tbOrd_id=Scope_Identity() Thanks SDH
  4. sdh

    Newbie help two routers

    I have two broadband connection now on our network 1 adsl line and one sattelite i have two routers 'wireless adsl router' and satelittle router How can i set the network up to use either or both of the gateways satellite is currently 192.168.0.130 (network range 192.168.0.1 to...
  5. sdh

    maintaining state of Multiselect form select with ASP

    I am looking to post a page back to itself for confirmation and cannot find how to maintain the state of a select box which has multiselect set can anybody help PLEASE
  6. sdh

    multiple recordsets from sp

    Please help I want to concatenate the results from three recordsets returned from one procedure the procedure is simply ALTER PROCEDURE [dbo].[usp_keywordSearch] ( @keywords varchar(2000) ) AS Begin DECLARE @CRC int -- Set parameter values EXEC @CRC =...
  7. sdh

    Remove duplicate xml nodes?

    Please help I have xml documents structured as below and want to transform them so it it only consists of records where there are no duplicate tbHrse_id value nodes <?xml version="1.0" ?> - <horses> - <horse> - <field name="tbHrse_Name"> <value>NO COMPLAINTS</value> </field> - <field...
    • sdh
    • Thread
    • Replies: 2
    • Forum: XML
  8. sdh

    Return Codes

    Can anyone tell me what it means if my stored procedure returns -6 Thx Sdh
  9. sdh

    Concatenating fields

    I get the following error from the query analyzer when I try to run this query Server: Msg 457, Level 16, State 1, Procedure usp_keywordSearchLineageAllAncestrytable, Line 10 Implicit conversion of char value to char cannot be performed because the collation of the value is unresolved due to...
  10. sdh

    New to Stored Procedure

    New to stored procedures I have just created this to update two tables in my db Problem is when the procedure is executed the first table has the records inserted but the second is not Any pointers as to why would be very helpful CREATE PROCEDURE [dbo].[sp_AddNewUser] ( @tbUsr_BadgeNo...
  11. sdh

    Server out of memory

    Any idea why I get server out of memory with this search code <% Dim iCount Dim arrSearchTerm GetFilenames '---------------------------------------------------- 'Name: Searchit(Filename) 'Purpose: Text based in site search engine 'Parmaters: strFilename (String)- Page to be...
  12. sdh

    Best practice for interval event

    I have a vb app that I want to fire an event when the system date matches that stored in the application the interval will be at least a week possible longer. I obviously cannot directly use the timer control and want to reduce payload on the machine any suggestions and or code would be...
  13. sdh

    connection via vb

    I cannot seem to make a connection via vb to sybase asa used by a commercial package i have can anyone help me with connection strings parameters etc. many thankds in anticipation sdh ::-)
  14. sdh

    connecting to Sybase SQL Anywhere from VB

    Has any body within this forium had any experience of connecting to sybase sql anywhere. My boss has just challenged me to connect to a sybase database used on our machines by a commercial software package we are using. |Bit of a new one to me I have no odbc drivers or anything. Can somebody...
  15. sdh

    Image format ???

    When trying to open a wpg image in paintshop pro 7 it says file type not supported but the manual states it is can anyone help me trying to open these images. thank you sdh::-)
  16. sdh

    for.. Loop New Javascripter needs help!!

    Below is my script. It is supposed to check the radio buttons and return there value to the text box but it only works for the first radio button. Form is called frmregister and the input code is as below. Please please help <script type=&quot;text/javascript&quot...
  17. sdh

    VB-Access-SQL Date format problem help please

    I have a database (Access) which has a table in it created with the following sql statement in vb code sqltext = &quot;CREATE TABLE Reports (ID COUNTER CONSTRAINT Recid PRIMARY KEY, RepDate datetime,report_name text,&quot; sqltext = sqltext & &quot; Userid text, Country text,Unit text,Yr...
  18. sdh

    File monitoring

    In an app I am writing, I watch a folder to see if files are placed there if so they are processed. The problem I have my app using the code below tells me when the file is placed in the directory but not when it has finished writing the file. This is the information I need to know for it to be...
  19. sdh

    Connection strings ADO

    Could anyone tell me the appropriate connection string to connect to an access database on a remote machine over the internet. I have heard it can be down but cannot find any info. sdh ::-)
  20. sdh

    PDF active x automation

    I have an app that uses the pdf active x to bring the pdf window into my form using the src method. I see there is also a print method I have downloaded the acrobat sdk but cannot find the args for the print method and they are not shown in the vb ide can anyone help. I would be very grateful sdh

Part and Inventory Search

Back
Top