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 Chriss Miller 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: gsc123
  • Content: Threads
  • Order by date
  1. gsc123

    SQL Server 2008 setup

    Can anyone advise please how to setup SQL Server 08.. what are the required components to install to use queries, create tables, etc... similar user environment to have an access database - i've added a link to view
  2. gsc123

    I have a site in ASP

    How easy is it to convert to PHP
    • gsc123
    • Thread
    • Replies: 9
    • Forum: PHP
  3. gsc123

    why dont this work. function

    Function pPriceMaxBidNotMine() 'get the highest bid for this item not belonging to me sql = "SELECT TOP 1 bidhistory.bidAmount AS price FROM bidhistory WHERE (((bidhistory.idProduct)="&Session("pIdProduct")&") AND ((bidhistory.idCustomerBid) <> "&session("idcustomer")&")) ORDER BY...
  4. gsc123

    Problem for session

    I have a bit of a problem, I seem to be re-inventing the wheel around my site the problem lies with two talbe products and bidhistory products as a price(which is current high bid and 0 if no bids) and startprice, the starting price of the item Bidhistory is empty if there are no bids so I...
  5. gsc123

    anyone fancing code clean up?

    I'm going mad looking at this can anyone tidy it up please? <%if Request.QueryString("frst") = "1" then%> <%Session("highbidder") = false%> <form method="post" action="pt_showcart.asp?processbid=1" name="recalculate"> <!-- first step is here confirm bid--> <%elseif...
  6. gsc123

    ERROR MYSTERY

    I get an error on these catchers but the query is valid? mySQL="UPDATE products SET products.Price = "&Session("pPrice")&" WHERE (((products.idproduct)="&Session("pIdProduct")&"))" conntemp.execute(mySQL) if err.number <> 0 then response.redirect "pt_supporterror.asp?error="&...
  7. gsc123

    return values off recordset

    If i use this query SELECT TOP 2 bidhistory.bidAmount AS price FROM bidhistory WHERE (((bidhistory.idProduct)=1560) AND ((bidhistory.idCustomerBid)<>15)) ORDER BY bidhistory.bidAmount DESC how do I get both values? or specify a particular value... ie; I want the second one
  8. gsc123

    query to support lowest bid

    I'm moving to SQL Server 08 soon so I'd like to drop this problem here... Hello, I have a problem with this query SELECT Min(bidAmount) AS price FROM BidHistory WHERE (((BidHistory.bidAmount) In (SELECT Min(BidAmount) FROM BidHistory WHERE BidAmount<10009999 and idproduct = 1560))) It will...
  9. gsc123

    Problem with a Min bid query

    Hello, I have a problem with this query SELECT Min(bidAmount) AS price FROM BidHistory WHERE (((BidHistory.bidAmount) In (SELECT Min(BidAmount) FROM BidHistory WHERE BidAmount<10009999 and idproduct = 1560))) It will always select min bid from the bidhistory table, the problem is, it will...
  10. gsc123

    Can this code be better

    Could this code be better as a query rather than wrapping a execute in this loop? first query is SELECT products.Description, products.Price, products.ImageUrl, products.idproduct, products.endDate, suppliers.idsupplier, suppliers.supplierName FROM suppliers INNER JOIN products ON...
  11. gsc123

    The best way to handle dates and times in access or sql

    Hi What is the best way to handle dates and times in access or sql? seperate columns days hours minutes etc. or one column date/time because I'm having all sorts of errors due to the way access stores them
  12. gsc123

    QUERY FOR PROXY

    Hi, I've place this question here because its relavant to this forum... sorry about the other post I need the following query I use this query to get most of the information, the price is updated in two tables, one bidhistory and the other the products, so I need somewhere in this select...
  13. gsc123

    SQL PROXY BID QUERY

    Hi, I've place this question here because its relavant to this forum. I need the following query I use this query to get most of the information, the price is updated in two tables, one bidhistory and the other the products, so I need somewhere in this select query to pull out min bid for...
  14. gsc123

    QUERY TO SHOW LOWEST BID

    Hi Need a query to show lowest bid for that user, ie: user1 has bid 250 user2 has bid 320 as a proxy so when user1 logs in he only sees next bid as 260 an then if he bids i can use a query to notify that the bid is not high enuf .. any help is welcome
  15. gsc123

    ROUNDED CORNERS

    Hello, Anyone tell me how I get rounded corners at the top of the page and the bottom like this site has? http://www.axialis.com/
  16. gsc123

    exporting access tables

    hello, is it possible to create tables in sql server directly from tables in access? Some sort of import?
  17. gsc123

    THE NOW FUNCTION AND ADD SOME

    Is it possible to add more days to the Now() function in a select statement or would I use a select to add 7 dyas plus the time now()?
  18. gsc123

    PARSING DATE AND TIME

    I is it possible parse this time and date inot its coresponding bits? 8/6/2009 21:15:58 ie: 8 = day 6 = mth ...and so on, tried ages and now baffled
  19. gsc123

    CLOCK AND CALENDER

    i want to add the date and time to a database from a form so it needs to be a selectable time and date so there are no errors submitting, is there anything out their to use to pick date and time?
  20. gsc123

    clock form

    i want to add the date and time to a database from a form so it needs to be a selectable time and date, is there anything out their to use to pick date and time?

Part and Inventory Search

Back
Top