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

    Declaring a class for use throughout a code behind page

    Hi All, I'm trying to find a way to declare a class in a code behind page that will allow me to use it within different functions and procedures without having to declare it each time. Another question while I'm asking, when I declare the class, I pass it a userID which is stored as a session...
  2. johnrg1

    Advice on a large query

    It got it to work :) My solution is DECLARE @start smalldatetime DECLARE @end smalldatetime SELECT @start ='20040101' SELECT @end = '20040201' WHILE @start <= @end BEGIN IF DATEPART(dw,@start) = 1 BEGIN INSERT INTO tbl_Rota (ShiftID, [Date]) SELECT...
  3. johnrg1

    Advice on a large query

    Thank you for your help. I'll let you know if I am successful or not. But fingers crossed :) John
  4. johnrg1

    Advice on a large query

    Simon, Please forgive my ignorance, could you please explain how this will work? WHILE DATEPART(dw,@j)<>2 - Why not equal to 2? I am thinking of something like this WHILE @j <= @LastDate IF DATEPART(dw,@j) = 1 BEGIN INSERT INTO Rota (ShiftID, [Date]) SELECT...
  5. johnrg1

    Advice on a large query

    Thanks for your replies guys, A bit more information as you requested. Default Table: ID ShiftID Day 1 1 1 2 3 1 3 5 2 4 1 2 Rota Table RotaID ShiftID Date 1 1 1/1/2000 I want to take all the default values...
  6. johnrg1

    Advice on a large query

    Hi All, I am about to write a Stored Procedure and thought i would ask if anyone had any advice. The query is to take values from a default table, and add them to another "live" table. Every monday an "A" shift is to take place. - From the default table I want to take the that shift and make...
  7. johnrg1

    Set a GUID to null

    Hi All, I was wondering if anyone knows how, it at all, a guid can be removed from a table. Just the existing value, not the row. I have a table with a guid column that relates to another table and its value is a guid. I want to set the guid to nothing if it is deleted from the other table...
  8. johnrg1

    Select query form a table and List

    Thanks a lot, i'll give it a go. :)
  9. johnrg1

    Select query form a table and List

    Hi All, I am trying to find a way to use a stored procedure to filter out the records i do not want rather than in my program. I have a list of shifts that are linked to a piece of equiptment, which has an equiptmentID. I have a table that links workerID's to what equiptment they can work...
  10. johnrg1

    Very Wierd March Date problem

    I've got the most recent release. 4.3.4. Any idea how to stop it?
  11. johnrg1

    Very Wierd March Date problem

    Hi All, I am have been looking into why a script of mine does not work, when I came across i very strange error. My server does not like the day 29th March 2004. Then when i dig a little deeper, it turns out it does not like the last Sunday of March in any year. Although I am able to format...
    • johnrg1
    • Thread
    • Replies: 3
    • Forum: PHP
  12. johnrg1

    Very Strange Problem

    Fixed that problem! there where no brackets in the While statement :| BUT... but he says... it is only pulling out 1 entry, then there should be 2. i can see them in the database, and extract them out using SQL on the database itself, but the page is only displaying 1 row. I can change wht is...
  13. johnrg1

    Very Strange Problem

    ...howdo you connect to your database? I use the following code: connect($dbhost, $dbuser, $dbpass, $dbname); $query_ProductDetails = &quot;SELECT * FROM tbl_product&quot;; $ProductDetails = mysql_query($query_ProductDetails); $row_ProductDetails = mysql_fetch_assoc($ProductDetails); but is...
  14. johnrg1

    Very Strange Problem

    ...and these values are not being retunrd from the database either :| This is the code i am using in full: $query_ProductDetails = &quot;SELECT * FROM tbl_product WHERE tbl_product.rma_id = $vRMA_ID ORDER BY line_ID DESC&quot;; $ProductDetails = mysql_query($query_ProductDetails)...
  15. johnrg1

    Very Strange Problem

    Hi All, I'm very new to PHP, I'm an ASP guy traditionally. I have come across a very strange problem when extracting data from a MySQL DB. It seems to &quot;skip&quot; bits of data. I have used the following code: echo &quot;Serial Number: $row[SerialNo] echo &quot;Repair Type: &quot...
    • johnrg1
    • Thread
    • Replies: 7
    • Forum: PHP
  16. johnrg1

    datagrid button column question

    I do this through a stylesheet. Define your style in a style sheet, style.css is the standard one VS.NET creates. Then use <asp:ButtonColumn ButtonType=&quot;LinkButton&quot; Text=&quot;Append&quot; CommandName=&quot;Append&quot; CssClass=&quot;STYLENAMEHERE&quot;/> This will then add the...
  17. johnrg1

    Real Challange

    Yes. I uploaded it an installed it myself! I am currently installing the servie packs to see if the help.
  18. johnrg1

    Real Challange

    Hi all. I'm looking for the genius of all genius's! I have wrtitten an DLL in VB to access a MS Word installation on a server to use its thesaurus components. Why i hear you ask, well becuase the client insists it is needed! Well, i have it working on my test server, and i also have it...
  19. johnrg1

    Changing Database connections

    cheers Rhys :)
  20. johnrg1

    Changing Database connections

    In ASP, an include file could be used to hold the the database connection string, meaning changing it in the one file would mean the entire site would connect differently. is there a way to do this in ASP.NET? At the moment i use VS.NET to create a connection, from which i drag the data onto...

Part and Inventory Search

Back
Top