Search results for query: *

Its a whole new world.. which do you prefer?

Yes but after that there is an option list .. which do I install? I did click of of them and got SQL server agent errors

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

Well its meanly SQL driven - but yes, many functions.. can you convert this to PHP so I can see where your coming from? Function processSQLruns(valType) select case valType case 1 sql = "SELECT TOP 1 bidhistory.bidAmount AS price FROM bidhistory WHERE...

How easy is it to convert to PHP

This was the problem rsMax = Nothing

found one porblem set rsMyMax = conntemp.execute(sql) if err.number <> 0 then Response.Write err.Description 'Response.Write sql if not rsMyMax.EOF or not rsMyMax.BOF then pPriceMaxBidMine = rsMyMax("price") processSQLruns = pPriceMaxBidMine else...

Why no matter what I do I still get the error, creashes the function, wont give me a reply? sql = "SELECT TOP 1 bidhistory.bidAmount AS price FROM bidhistory WHERE (((bidhistory.idProduct)="&Session("pIdProduct")&") AND ((bidhistory.idCustomerBid)="&session("idcustomer")&")) ORDER BY...

and heres another SELECT TOP 1 bidhistory.bidAmount AS price FROM bidhistory WHERE (((bidhistory.idProduct)=1560) AND ((bidhistory.idCustomerBid)=1487)) ORDER BY bidhistory.bidAmount DESC This query returns 0 because there are no fields, why is this flagging an error? Either BOF or EOF is...

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

can I see code?

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

Yes its the error Either BOF or EOF has been reached?

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

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="&...

if I was to directly access 2nd field how would I grab it

Thats good, how would I align it centre of the screnn with the background of the mainpage c0c0c0 and the <div foreground white?

How would that appear in the browser as a date?

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

I have'nt switched over to SERVER yet, is this possible to convert to access query or not? or is access not supportable for this type of query?