ASP Free Forums - ASP Help, ASP Tutorials, ASP Programming, ASP Code, ASP Hosting

query help

nicklibee — Thu, 20 Jun 2013 07:54:58 GMT

Dear all,

I have following tables

TABLE : A

ENTERPRISE_MAIN_CODE ENTERPRISE_SUB_CODE ENTERPRISE_DESCRIPTION
1 0 A
2 0 B
3 0 C
4 0 D
5 0 E
6 0 F
7 0 G
8 0 H
9 0 I

TABLE : B

ID_NO ENTERPRISE_MAIN_CODE ENTERPRISE_SUB_CODE
1 1 1
2 1 2
3 7 1
4 4 1
5 4 1
6 6 1
7 6 5

TABLE : C
ID_NO ENTERPRISE_ID_NO ENTERPRISE_DATE ENTERPRISE_AMT
1 1 20130109 1000
1 2 20130315 2000
2 3 20120120 3000
2 4 20120305 4000
3 5 20141111 5000
4 6 20130115 6000
5 7 20130320 7000

user inputs only month and year: for example 201303.

the date format is yyyymmdd

o/p details: it has 4 parts which are explained below

1. User should see the count and the amount of the selected year and month (201303 i.e 2013 march data)

2. the previous year of the selected year and month ( count and the amount ) (201203 i.e 2012 march data)

3. the first month of selected year till the selected year's selected month (count and the amount) ( 20130101 - 20130330 )

4. the first month of previous year till the previosu year's month (count and the amount) ( i.e 20120101 - 20120330 )

The expected op is as follows

1. 2. 3. 4.

ENTERPRISE_DESCRIPTION count amt count amt count amt count amt
A 1 2000 1 4000 2 3000 2 7000
B 0 0 0 0 0 0 0 0
C 0 0 0 0 0 0 0 0
D 1 7000 0 0 2 13000 0 0
E 0 0 0 0 0 0 0 0
F 0 0 0 0 0 0 0 0
G 0 0 0 0 0 0 0 0
H 0 0 0 0 0 0 0 0
I 0 0 0 0 0 0 0 0

Thanks

Nick

Beginner query question

healthstudent — Thu, 20 Jun 2013 02:33:48 GMT

I truly apologize if this is anything that has been asked before. I tried to use the search function, but could not turn up anything on the keywords I used.

I have a database of patient information - with tables recording dates they had particular services done. I am trying to build a query to indicate whether or not each patient has had two of a particular service done within the year a certain amount of days apart. The easiest way to come up with this number seems to be to take the first date and the last date and subtract the difference. However, when building the query if I select "first" from the "total" drop down to appear in one column in the completed query, and "last"in another, and then use DateDiff to subtract the differences - it is not actually pulling the first date and the last date, it's pulling random ones - some records show up right and some wrong. (Initially this is how I was instructed to do it from someone who basically does this for a living). My first thought is that it wasn't actually pulling it based on the date itself but when the date was recorded in the table - can anyone confirm if this assumption is correct? To remedy this, I decided to use min and max instead. This actually works for the most part. If there is any way to link each date to a field in a table recording the corresponding test result that would solve all my problems. Lastly, I ran into problems trying to constrain the query to one year in the criteria box, using >=#6/19/2012# Instead of completely ignoring those dates of service recorded before the indicated date and pulling a new minimum after 6/19/2012, it seems to be ignoring all PATIENTS that do not meet the criteria of their minimum date of service being after this date. I hope that makes sense.

The goal of the project is to keep it simple, allowing physicians to simply update the records in each table, change the date constraints in the query, and spit out a reports every month for a quality improvement meeting. I'm in an internship working on this project that didn't even start out as an Access database to begin with, with minimal Access experience from a job in high school. Simply put... I'm confused. :confused: I would appreciate any direction and help I can get. Thanks everyone.

Help with Batch Script FindStr to search for a string and matching line

PeterTheSeeker — Thu, 20 Jun 2013 02:21:43 GMT

Hi Gurus,

I've been having some problem in using FIND or FINDSTR command to find a particular string in a log file and return its output with the matching string along with 1 line above and 1 line below the matching line.

So far, this is the only command that I've tried. I've tried to search online, but couldn't find anything useful.

findstr /n "ERROR DETECTED" c:\Log.txt

Sample log data (Log.txt):

Code:

1371524155  Tue Jun 18 10:55:55 2013

1371524160  Tue Jun 18 10:56:00 2013

1371524165  Tue Jun 18 10:56:05 2013

ERROR DETECTED

 1371523243  Tue Jun 18 10:40:43 2013

1371523248  Tue Jun 18 10:40:48 2013

1371523253  Tue Jun 18 10:40:53 2013

Desire output (Example):

Code:

1371524160  Mon Jun 10 08:50:01 2013

ERROR DETECTED

 1371523241  Mon Jun 10 08:20:41 2013



1371524165  Tue Jun 18 10:56:05 2013

ERROR DETECTED

 1371523243  Tue Jun 18 10:40:43 2013

There maybe more than 1 occurance of the string "ERROR DETECTED" in the log file as it can contain a lot of data. So the script should be able to handle it and output the multiple result of the searched string as shown in the above example.

Appreciate for your kind help.

Thank you.

Trying to get my Ajax AutoCompleteExtender to read from my SQL CE database..

codeman061988 — Wed, 19 Jun 2013 23:27:13 GMT

Hello everyone,

I've got an interesting challenge I've been wrestling with for a few days now. Despite extensive research, I cannot seem to find a good solution to the problem.

I've got an Ajax AutoCompleteExtender pointing to a text box. As you are hopefully aware of, this control functions by suggesting results as the user types a search in the text box. I actually followed a simple tutorial to implement the control into my ASP.NET page..Creating a Simple Auto-Complete TextBox - ASP.NET Ajax Library..Upon completion, I was able to get suggested items to populate as I was typing. This is because the item strings are were stored in the code behind. Instead, I want populate items, from a table, in a specific row, from an SQL CE database.
I've seen tutorials on how to get the data from a regular SQL database, located elsewhere on the the computer but none showing how to get the data from a CE database.

Here is my ASP.NET code:

Code:









    

    
        CompletionListCssClass="AutoExtender"

        CompletionListItemCssClass="AutoExtenderListItem"

        CompletionListHighlightedItemCssClass="AutoExtenderItemHighlighted"

        ID="AutoCompleteExtender1"

        TargetControlID="ClientSearch"

        runat="server" 

        ServiceMethod="GetCompletionList" 

        MinimumPrefixLength="1"

        UseContextKey="True">

Here is the code behind (Were I need to change something to make it get data from the CE database (C#):

Code:

using System.Data;

using System.Data.SqlClient;

using System.Collections.Generic;

using System.Configuration;

using System;





public partial class _Default : System.Web.UI.Page



{

    protected void Page_Load(object sender, EventArgs e)

    {



    }



    [System.Web.Script.Services.ScriptMethod()]

    [System.Web.Services.WebMethod]

    public static List GetCompletionList(string prefixText)

    {

        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());

        con.Open();

        SqlCommand cmd = new SqlCommand("select * from Current where Name like @Name+'%'", con);

        cmd.Parameters.AddWithValue("@Name", prefixText);

        SqlDataAdapter da = new SqlDataAdapter(cmd);

        DataTable dt = new DataTable();

        da.Fill(dt);

        List Names = new List();

        for (int i = 0; i < dt.Rows.Count; i++)

        {

            Names.Add(dt.Rows[i][1].ToString());

        }

        return Names;

    }





}

Finally, here is the Connection String, located in my Web.config file. I would hop to somehow use this same string in the code behind file:

Code:

When I run the current code above, I get an exception (I assume it is because the code is trying to reach a database in SQL, rather than a CE database):

A network-related or instance-specific error occurred while establishing a connection to SQL Server.
The server was not found or was not accessible.
Verify that the instance name is correct and that SQL Server is configured to allow remote connections.

From dome forums I've read, I could change the SqlConnection in the code behind to SqlCeConnection. I actually tried this but apparently I'm also missing a name space.

Any Ideas?

path not found error

vreid — Wed, 19 Jun 2013 18:50:47 GMT

I'm bran new to ASP. Background info. I've been set up on a server. I've one line of code that's throwing an error "path not found". Is it because I'm on a server and need to type in the location a different way?

Code:

Set peoplefile=FileSys.OpenTextFile( "Z:\vreid\gbpeople.txt",8,true)

Let discuss various prospects of search engine optimization

Click SSL — Wed, 19 Jun 2013 08:42:13 GMT

When I came here at SEO section of this forum I never found any live discussion on the topic of search engine optimization. As Google has just rolled out lots of website from organic search results after latest penguin 2.0 update what would be next text techniques of webmaster to rank higher on Google and beat competitors?

Expecting useful and interesting answers from you mates.

Iis arr

jeco — Wed, 19 Jun 2013 08:15:31 GMT

Hi, our company would like to setup Lotus Traveler for remote users access using either IPhone or Android phones but our Global partners recommended to have a reverse proxy on the front end facing the internet for security purposes. And this reverse proxy will be responsible for ldap authentication on the DC.

Things I've done so far:

1. Installed Windows Server 2008 R2 SP1 on the reverse proxy server and done installing IIS ARR

2. Installed Windows Server 2008 R2 SP1 on the Lotus Traveler Server and done installing Lotus Domino for users to browse over the server and download the required software for their respective mobile type.

Temporarily setup an administrator just for testing to be able to access the site and download the software for iphone and Android but eventually would like to use windows authentication to be able to access the site.

Has anyone done this before? using IIS ARR

Jeff

Database on Separate Server

geog272 — Tue, 18 Jun 2013 21:06:16 GMT

Hi, I currently use an ODBC connection to connect to an access database on the same server as the ASP files. I would like to move the database to a separate server (but still within the LAN). Can anyone point me to a how-to on making this kind of database connection? I feel like I should be finding something googling it, but I must not be using the right search terms. Also, if anyone has any recommendations on whether this is good or bad in terms of performance, please chime in!

Thanks in advance.

asp news feed

Lokiey — Tue, 18 Jun 2013 16:46:08 GMT

Hey everyone im lokiey, im brand new to coding and asp and i need some help figuring something out that's been killing me for over a week now. I created a news feed so admins on my site can post current news that's posted on the main page but lacks the one feature i feel it needs, Im trying to figure out how to add a move up/move down button to each news posted aside from the one posted at the top which only has a move down button giving you freedom to move them in the order of importance. I honestly cant figure out how to do this and the developer doesn't have time to do it so i must learn as i go for some things. So any help as to where to begin would be greatly appreciated because im at a complete loss on how to create these tables and functionality to this news feed and would like to learn how.

Disk 0 and Disk 3 Swap

meratigoerr — Tue, 18 Jun 2013 14:56:09 GMT

I have a Dell PowerEdge R510. Connected to it, thru an H810 card is a Power Vault. The servers has 4 drives in a raid 6 array. Partitioned to Drives C: and D:. The OS (Server 2008 r2) is on the C partition. The power Vault is setup in 3 Raid 6 configuration. Drive S: Drive T: Drive U:. Viewed in computer management Drives C: and D: are Disk 3. Drive S is Disk 0, T is Disk 1, and U is Disk 2. I know that this is normally not an issue, it will cause no errors under regular use. However we use a Unitrends Backup system. While the backups function normally, I am unable to do a virtual restore of this server. I was told by tech support at Unitrends it is because the OS must be on Disk 0. The error I'm getting is that it can't locate drives S, T, U. (because the Disk numbers come before the OS, not after.)

So the question is: How to make the current Disk 3, Disk 0? The other Disks don't matter as long as they come after 0.

I've searched thru the Bios, couldn't find any type of settings to modify this. I've searched thru the management console, saw nothing. Internet searching always comebacks with "It's not an issue because it will not cause any errors, so just leave it as it is." Unfortunately not the result in my case. Anyone know how to do this?

(unanswered cross post at: Disk 0 Swap with Disk 3)

Using checkboxes to refine search results - query string?

wozwebs — Tue, 18 Jun 2013 11:42:18 GMT

Hi there, I have a search facility on a clients property website. It is using MS SQL and classic ASP for the coding.

I have it set up so that clicking on 'Office' pulls in all of the office properties they have listed. They now want to be able to narrow this down to locations.

I added a new field called 'proploc' and amended all of the current properties to give them a 'proplocid' (1 = Manchester, 2 = Liverpool, 3 = London etc., there are 8 in total)

I added links on the Offices page so that they can go to each location, eg:

offices.asp?proplocid=1 brings in all properties in Manchester only
offices.asp?proplocid=2 brings in all properties in Liverpool only
offices.asp?proplocid=3 brings in all properties in London only

What they want though is to have checkboxes and a 'Go' button so that the user could select more than one location and then click Go to bring in both Liverpool and London properties (proplocid's 1 and 3)

How do I go about this in terms of it generating the correct link? I know I am using old code in classis ASP but it does work for me generally.

Here is the source code I am using before the opening html tag:

Code:

<%@LANGUAGE="VBSCRIPT"%> 



<%

Dim rs__varsection

rs__varsection = "1"

if (request("section")   <> "") then rs__varsection = request("section")  

%>

<%

Dim rs__varstatus

rs__varstatus = "%"

if (request("status")  <> "") then rs__varstatus = request("status") 

%>

<%

Dim rs__varproploc

rs__varproploc = "%"

if (request("proploc")  <> "") then rs__varproploc = request("proploc") 

%>

<%

Dim rs__varpl

rs__varpl = "0"

if (Request.QueryString("minprice")  <> "") then rs__varpl = Request.QueryString("minprice") 

%>

<%

Dim rs__varpu

rs__varpu = "99999999999999"

if (Request.QueryString("maxprice")  <> "") then rs__varpu = Request.QueryString("maxprice") 

%>

<%

set rs = Server.CreateObject("ADODB.Recordset")

rs.ActiveConnection = Conn

rs.Source = _

    "SELECT *  FROM prop, section, status, proploc" _

  & " WHERE status = statusid AND section = sectionid AND proploc = proplocid" _

  & " AND section in (1,5,6,7) " _

  & " AND status like '" & Replace(rs__varstatus, "'", "''") & "' " _

  & " AND proploc like '" & Replace(rs__varproploc, "'", "''") & "' " _

  & " AND price between " & CDBL(rs__varpl) & " AND " & CDBL(rs__varpu) _

  & " ORDER BY price DESC"



rs.CursorType = 0

rs.CursorLocation = 2

rs.LockType = 3

rs.Open()

rs_numRows = 0

%>

<%

Dim rs2__MMColParam

rs2__MMColParam = "1"

if (Request.QueryString("statusid") <> "") then rs2__MMColParam = Request.QueryString("statusid")

%>

<%

set rs2 = Server.CreateObject("ADODB.Recordset")

rs2.ActiveConnection = Conn

rs2.Source = "SELECT * FROM status WHERE statusid = " + Replace(rs2__MMColParam, "'", "''") + ""

rs2.CursorType = 0

rs2.CursorLocation = 2

rs2.LockType = 3

rs2.Open()

rs2_numRows = 0

%>





<%

Dim rs4__MMColParam

rs4__MMColParam = "1"

if (Request.QueryString("proplocid") <> "") then rs4__MMColParam = Request.QueryString("proplocid")

%>

<%

set rs4 = Server.CreateObject("ADODB.Recordset")

rs4.ActiveConnection = Conn

rs4.Source = "SELECT * FROM proploc WHERE proplocid = " + Replace(rs4__MMColParam, "'", "''") + ""

rs4.CursorType = 0

rs4.CursorLocation = 2

rs4.LockType = 3

rs4.Open()

rs4_numRows = 0

%>







<%

Dim Repeat1__numRows

Repeat1__numRows = 10

Dim Repeat1__index

Repeat1__index = 0

rs_numRows = rs_numRows + Repeat1__numRows

%>

<%

'  *** Recordset Stats, Move To Record, and Go To Record: declare stats variables



' set the record count

rs_total = rs.RecordCount



' set the number of rows displayed on this page

If (rs_numRows < 0) Then

  rs_numRows = rs_total

Elseif (rs_numRows = 0) Then

  rs_numRows = 1

End If



' set the first and last displayed record

rs_first = 1

rs_last  = rs_first + rs_numRows - 1



' if we have the correct record count, check the other stats

If (rs_total <> -1) Then

  If (rs_first > rs_total) Then rs_first = rs_total

  If (rs_last > rs_total) Then rs_last = rs_total

  If (rs_numRows > rs_total) Then rs_numRows = rs_total

End If

%>

<%

' *** Recordset Stats: if we don't know the record count, manually count them



If (rs_total = -1) Then



  ' count the total records by iterating through the recordset

  rs_total=0

  While (Not rs.EOF)

    rs_total = rs_total + 1

    rs.MoveNext

  Wend



  ' reset the cursor to the beginning

  If (rs.CursorType > 0) Then

    rs.MoveFirst

  Else

    rs.Requery

  End If



  ' set the number of rows displayed on this page

  If (rs_numRows < 0 Or rs_numRows > rs_total) Then

    rs_numRows = rs_total

  End If



  ' set the first and last displayed record

  rs_first = 1

  rs_last = rs_first + rs_numRows - 1

  If (rs_first > rs_total) Then rs_first = rs_total

  If (rs_last > rs_total) Then rs_last = rs_total



End If

%>

<%

' *** Move To Record and Go To Record: declare variables



Set MM_rs    = rs

MM_rsCount   = rs_total

MM_size      = rs_numRows

MM_uniqueCol = ""

MM_paramName = ""

MM_offset = 0

MM_atTotal = false

MM_paramIsDefined = false

If (MM_paramName <> "") Then

  MM_paramIsDefined = (Request.QueryString(MM_paramName) <> "")

End If

%>

<%

' *** Move To Record: handle 'index' or 'offset' parameter



if (Not MM_paramIsDefined And MM_rsCount <> 0) then



  ' use index parameter if defined, otherwise use offset parameter

  r = Request.QueryString("index")

  If r = "" Then r = Request.QueryString("offset")

  If r <> "" Then MM_offset = Int(r)



  ' if we have a record count, check if we are past the end of the recordset

  If (MM_rsCount <> -1) Then

    If (MM_offset >= MM_rsCount Or MM_offset = -1) Then  ' past end or move last

      If ((MM_rsCount Mod MM_size) > 0) Then         ' last page not a full repeat region

        MM_offset = MM_rsCount - (MM_rsCount Mod MM_size)

      Else

        MM_offset = MM_rsCount - MM_size

      End If

    End If

  End If



  ' move the cursor to the selected record

  i = 0

  While ((Not MM_rs.EOF) And (i < MM_offset Or MM_offset = -1))

    MM_rs.MoveNext

    i = i + 1

  Wend

  If (MM_rs.EOF) Then MM_offset = i  ' set MM_offset to the last possible record



End If

%>

<%

' *** Move To Record: if we dont know the record count, check the display range



If (MM_rsCount = -1) Then



  ' walk to the end of the display range for this page

  i = MM_offset

  While (Not MM_rs.EOF And (MM_size < 0 Or i < MM_offset + MM_size))

    MM_rs.MoveNext

    i = i + 1

  Wend



  ' if we walked off the end of the recordset, set MM_rsCount and MM_size

  If (MM_rs.EOF) Then

    MM_rsCount = i

    If (MM_size < 0 Or MM_size > MM_rsCount) Then MM_size = MM_rsCount

  End If



  ' if we walked off the end, set the offset based on page size

  If (MM_rs.EOF And Not MM_paramIsDefined) Then

    If (MM_offset > MM_rsCount - MM_size Or MM_offset = -1) Then

      If ((MM_rsCount Mod MM_size) > 0) Then

        MM_offset = MM_rsCount - (MM_rsCount Mod MM_size)

      Else

        MM_offset = MM_rsCount - MM_size

      End If

    End If

  End If



  ' reset the cursor to the beginning

  If (MM_rs.CursorType > 0) Then

    MM_rs.MoveFirst

  Else

    MM_rs.Requery

  End If



  ' move the cursor to the selected record

  i = 0

  While (Not MM_rs.EOF And i < MM_offset)

    MM_rs.MoveNext

    i = i + 1

  Wend

End If

%>

<%

' *** Move To Record: update recordset stats



' set the first and last displayed record

rs_first = MM_offset + 1

rs_last  = MM_offset + MM_size

If (MM_rsCount <> -1) Then

  If (rs_first > MM_rsCount) Then rs_first = MM_rsCount

  If (rs_last > MM_rsCount) Then rs_last = MM_rsCount

End If



' set the boolean used by hide region to check if we are on the last record

MM_atTotal = (MM_rsCount <> -1 And MM_offset + MM_size >= MM_rsCount)

%>

<%

' *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters



' create the list of parameters which should not be maintained

MM_removeList = "&index="

If (MM_paramName <> "") Then MM_removeList = MM_removeList & "&" & MM_paramName & "="

MM_keepURL="":MM_keepForm="":MM_keepBoth="":MM_keepNone=""



' add the URL parameters to the MM_keepURL string

For Each Item In Request.QueryString

  NextItem = "&" & Item & "="

  If (InStr(1,MM_removeList,NextItem,1) = 0) Then

    MM_keepURL = MM_keepURL & NextItem & Server.URLencode(Request.QueryString(Item))

  End If

Next



' add the Form variables to the MM_keepForm string

For Each Item In Request.Form

  NextItem = "&" & Item & "="

  If (InStr(1,MM_removeList,NextItem,1) = 0) Then

    MM_keepForm = MM_keepForm & NextItem & Server.URLencode(Request.Form(Item))

  End If

Next



' create the Form + URL string and remove the intial '&' from each of the strings

MM_keepBoth = MM_keepURL & MM_keepForm

if (MM_keepBoth <> "") Then MM_keepBoth = Right(MM_keepBoth, Len(MM_keepBoth) - 1)

if (MM_keepURL <> "")  Then MM_keepURL  = Right(MM_keepURL, Len(MM_keepURL) - 1)

if (MM_keepForm <> "") Then MM_keepForm = Right(MM_keepForm, Len(MM_keepForm) - 1)



' a utility function used for adding additional parameters to these strings

Function MM_joinChar(firstItem)

  If (firstItem <> "") Then

    MM_joinChar = "&"

  Else

    MM_joinChar = ""

  End If

End Function

%>

<%

' *** Move To Record: set the strings for the first, last, next, and previous links



MM_keepMove = MM_keepBoth

MM_moveParam = "index"



' if the page has a repeated region, remove 'offset' from the maintained parameters

If (MM_size > 0) Then

  MM_moveParam = "offset"

  If (MM_keepMove <> "") Then

    params = Split(MM_keepMove, "&")

    MM_keepMove = ""

    For i = 0 To UBound(params)

      nextItem = Left(params(i), InStr(params(i),"=") - 1)

      If (StrComp(nextItem,MM_moveParam,1) <> 0) Then

        MM_keepMove = MM_keepMove & "&" & params(i)

      End If

    Next

    If (MM_keepMove <> "") Then

      MM_keepMove = Right(MM_keepMove, Len(MM_keepMove) - 1)

    End If

  End If

End If



' set the strings for the move to links

If (MM_keepMove <> "") Then MM_keepMove = MM_keepMove & "&"

urlStr = Request.ServerVariables("URL") & "?" & MM_keepMove & MM_moveParam & "="

MM_moveFirst = urlStr & "0"

MM_moveLast  = urlStr & "-1"

MM_moveNext  = urlStr & Cstr(MM_offset + MM_size)

prev = MM_offset - MM_size

If (prev < 0) Then prev = 0

MM_movePrev  = urlStr & Cstr(prev)

%>

Any help would be most welcome on this.

automating sql commands

trevi — Mon, 17 Jun 2013 23:35:47 GMT

hi,

I would like to run scripts automatically in SQL Server 2008. I have script that creates databases, builds tables and updates them. I've run these manually, but it takes a long time to do this and I have roughly 12 databases to update. What is the best way I can automate these scripts so they can run by themselves? I read something about using a 'scripter' class, but is that the best option I have?

Thanks!

Mag

Is there a VBScribe MD5 convertor that takes both a "sMessage" & a secrete key?

dhuangfu — Mon, 17 Jun 2013 20:33:53 GMT

Is there a VBScribe MD5 convertor that takes both a "sMessage" & a secrete key?

List Box Horizontal Bars

ACNI — Mon, 17 Jun 2013 12:34:07 GMT

I was hoping someone could assist me. I am having an issue getting a horizontal bar to appear in a list box on Access Form. I have tried several things and haven't been able to accomplish it. Right now I have my column count at 1 and my column width at 1. Does anyone have any suggestions?

How to implement bidding concept in website? in Html & Asp

Jack Hard — Mon, 17 Jun 2013 10:49:26 GMT

Use an asynchronous technology such as AJAX, which connects back to the database every few seconds to update the auction details such, as the price and quantity left. Then when the quantity hits zero, you grab another product from the DB and start the process all over again. This method works well particularly well when combined with XML/JSON.

Ajax Tutorial for Beginners: Part 1[^]

Ajax Tutorial for Beginners with XML & JSON: Part 2[^]

I used to write falling-price auction sites like the ones you posted, and this is how they work. Normally you will want to set your javascript timer to refresh your auction details by calling the same AJAX function around every 3 seconds or so:

Collapse | Copy Code

setTimeout(function(){myAJAXFunc()},3000);

And if you're using Firefox, a nice way to track the XML being passed back is to use the XML/HTTP Request viewer in the Firebug plug-in, to see your AJAX data as it refreshes from the DB every few seconds.