|
| |
|
|
ianb
Posts: 20
Joined: 5/8/2006
Status: offline
 |
seperate records for each item - 6/15/2006 6:10:04
ok, ive searched and search but nothing.
im busy setting up a shopping cart, but at the end when the person is suppoed to check out and the items ordred are put into the database there is where i have the problem.
The items get submitted to the DB, but not in its own row, the items are all in one row seperated by commas e.g.
ItemQuantity1, Itemquantity2 | item 1, item2
and not like this:
ItemQuantity1 | item1
ItemQuantity2 | item2
here is the code that processes the form:
!--#include file="../_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="insert into OrdersConfirmed (UID, quantity, product) values ( '::UID::', '::quantity::', '::product::')"
fp_sDefault="UID=&quantity=&product="
fp_sNoRecords="No records returned."
fp_sDataConn="scart"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&"
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=2
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<p>
<!--webbot bot="PurpleText" PREVIEW="inserts the order details" --></p>
<!--#include file="../_fpclass/fpdbrgn2.inc"-->
</body></html>
here is the form that sends to above:
<html>
<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title></title>
</head>
<body>
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="95%" id="AutoNumber4">
<tr>
<td width="100%"><font face="Verdana" size="2"><b>Order:</b></font><form method="POST" action="processorder.asp">
<div align="center">
<center>
<table width="95%" border="0" style="border-collapse: collapse" bordercolor="#111111" cellpadding="0" cellspacing="0">
<thead>
<tr>
<td><b>Quantity</b></td>
<td><b>Product</b></td>
<td><b>Unit Price</b></td>
<td><b>Line Total</b></td>
</tr>
</thead>
<tbody>
<!--webbot bot="DatabaseRegionStart" s-columnnames="UID,orderID,productID,ProductPrice,ProductName,quantity" s-columntypes="202,3,2,202,202,2" s-dataconnection="scart" b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource="itemsOrdered" s-displaycolumns="UID,orderID,productID,ProductPrice,ProductName,quantity" s-criteria="[UID] EQ {UID} +" s-order s-sql="SELECT * FROM itemsOrdered WHERE (UID = '::UID::')" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields="UID=" s-norecordsfound="No records returned." i-maxrecords="256" i-groupsize="0" botid="2" u-dblib="../_fpclass/fpdblib.inc" u-dbrgn1="../_fpclass/fpdbrgn1.inc" u-dbrgn2="../_fpclass/fpdbrgn2.inc" tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font color="#000000">This is the start of a Database Results region.</font></td></tr>" startspan --><!--#include file="../_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM itemsOrdered WHERE (UID = '::UID::')"
fp_sDefault="UID="
fp_sNoRecords="<tr><td colspan=6 align=left width=""100%"">No records returned.</td></tr>"
fp_sDataConn="scart"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&UID=202&orderID=3&productID=2&ProductPrice=202&ProductName=202&quantity=2&"
fp_iDisplayCols=6
fp_fCustomQuery=False
BOTID=2
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="9132" --><tr>
<%
Response.buffer=True
If Session("mm_UserName") = "" Then Response.redirect "login.asp"
%>
<%
Total1 = 0
productprice = (FP_FieldHTML(fp_rs,"productprice"))
Quantity = (FP_FieldHTML(fp_rs,"quantity"))
ExtPrice = (FP_FieldHTML(fp_rs,"productprice") * (FP_FieldHTML(fp_rs,"quantity")))
total = Total + (Quantity * ProductPrice)
%>
<td>
<input type="text" name="quantity" size="20" value="<%=quantity%>"></td>
<td>
<input type="text" name="Product" size="20" value="<%=FP_FieldVal(fp_rs,"ProductName")%>"></td>
<td>
<input type="text" name="ProductPrice" size="20" value="<%=productprice%>"></td>
<td> <%=extprice%></td>
</tr>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE" b-menuformat="FALSE" u-dbrgn2="../_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr>" startspan --><!--#include file="../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="56926" --></tbody>
</table>
</center>
</div>
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="95%" id="AutoNumber7" height="16">
<tr>
<td width="25%" height="16"></td>
<td width="25%" height="16"></td>
<td width="25%" height="16"><font face="Verdana" size="2"><b>Total</b></font></td>
<td width="25%" height="16"><%=total%></td>
</tr>
</table>
</center>
</div>
<p><font face="Verdana" size="2"><b>Deliver To:</b></font></p>
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="95%" id="AutoNumber1">
<tr>
<td width="100%">
<!--webbot bot="DatabaseRegionStart" s-columnnames="U_ID,U_PASSWORD,U_FIRST,U_LAST,U_ADDRESS,U_CITY,U_STATE,U_ZIP,U_EMAIL,U_PHONE,U_FAX,Date,ACCESS" s-columntypes="202,202,202,202,202,202,202,202,202,202,202,135,202" s-dataconnection="classifieds" b-tableformat="FALSE" b-menuformat="FALSE" s-menuchoice="U_ID" s-menuvalue="U_ID" b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource="USERS" s-displaycolumns="U_ID,U_PASSWORD,U_FIRST,U_LAST,U_ADDRESS,U_CITY,U_STATE,U_ZIP,U_EMAIL,U_PHONE,U_FAX,Date,ACCESS" s-criteria="[U_ID] EQ {UID} +" s-order s-sql="SELECT * FROM USERS WHERE (U_ID = '::UID::')" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields="UID=" s-norecordsfound="No records returned." i-maxrecords="256" i-groupsize="0" botid="1" u-dblib="../_fpclass/fpdblib.inc" u-dbrgn1="../_fpclass/fpdbrgn1.inc" u-dbrgn2="../_fpclass/fpdbrgn2.inc" tag="BODY" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="left"><font color="#000000">This is the start of a Database Results region.</font></td></tr></table>" b-wastableformat="FALSE" startspan --><!--#include file="../_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM USERS WHERE (U_ID = '::UID::')"
fp_sDefault="UID="
fp_sNoRecords="No records returned."
fp_sDataConn="classifieds"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice="U_ID"
fp_sMenuValue="U_ID"
fp_sColTypes="&U_ID=202&U_PASSWORD=202&U_FIRST=202&U_LAST=202&U_ADDRESS=202&U_CITY=202&U_STATE=202&U_ZIP=202&U_EMAIL=202&U_PHONE=202&U_FAX=202&Date=135&ACCESS=202&"
fp_iDisplayCols=13
fp_fCustomQuery=False
BOTID=1
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="35199" --><p>
<font face="Verdana" size="2">
<input type="text" name="First" size="35" value="<%=FP_FieldVal(fp_rs,"U_FIRST")%>">
<input type="text" name="Last" size="35" value="<%=FP_FieldVal(fp_rs,"U_Last")%>"></font></p>
<p>
<font face="Verdana" size="2">
<input type="text" name="address" size="35" value="<%=FP_FieldVal(fp_rs,"U_address")%>">,
<input type="text" name="suburb" size="35" value="<%=FP_FieldVal(fp_rs,"U_city")%>"><b><br>
</b>
<br>
<input type="text" name="postalcode" size="35" value="<%=FP_FieldVal(fp_rs,"U_zip")%>"></font></p>
<p> </p>
<p><font face="Verdana" size="2">
<!--webbot bot="DatabaseResultColumn" s-columnnames="U_ID,U_PASSWORD,U_FIRST,U_LAST,U_ADDRESS,U_CITY,U_STATE,U_ZIP,U_EMAIL,U_PHONE,U_FAX,Date,ACCESS" s-column="U_EMAIL" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-menuformat preview="<font size="-1"><<</font>U_EMAIL<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"U_EMAIL")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="11534" --></font></p>
<p><font face="Verdana" size="2">
<!--webbot bot="DatabaseResultColumn" s-columnnames="U_ID,U_PASSWORD,U_FIRST,U_LAST,U_ADDRESS,U_CITY,U_STATE,U_ZIP,U_EMAIL,U_PHONE,U_FAX,Date,ACCESS" s-column="U_PHONE" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-menuformat preview="<font size="-1"><<</font>U_PHONE<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"U_PHONE")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="11519" --></font></p>
<p><font face="Verdana" size="2">
<!--webbot bot="DatabaseResultColumn" s-columnnames="U_ID,U_PASSWORD,U_FIRST,U_LAST,U_ADDRESS,U_CITY,U_STATE,U_ZIP,U_EMAIL,U_PHONE,U_FAX,Date,ACCESS" s-column="U_FAX" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-menuformat preview="<font size="-1"><<</font>U_FAX<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"U_FAX")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="7373" --></font></p>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE" b-menuformat="FALSE" u-dbrgn2="../_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="BODY" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="left"><font color="#000000">This is the end of a Database Results region.</font></td></tr></table>" startspan --><!--#include file="../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="56926" --><p>
<font face="Verdana" size="2"> </font></td>
</tr>
</table>
</center>
</div>
<p style="margin-top: 0; margin-bottom: 0">
<font face="Verdana" size="2"><b>Delivery Options:</b></font></p>
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="95%" id="AutoNumber5">
<tr>
<td width="100%">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber6">
<tr>
<td width="50%"><font face="Verdana">
<input type="radio" value="Collect" name="DeliveryOptions"><font size="2">I
Will Collect</font></font></td>
<td width="50%"><font face="Verdana">
<input type="radio" value="Post" name="DeliveryOptions"><font size="2">Please
send it to me</font></font></td>
</tr>
<tr>
<td width="50%"> </td>
<td width="50%"> </td>
</tr>
<tr>
<td width="50%"><font face="Verdana" size="2">Collections can
be made from:</font><p><font face="Verdana" size="2">Edenvale
JHB</font></p>
<p><font face="Verdana" size="2">Garsfontein PTA</font></td>
<td width="50%"><font face="Verdana" size="2">We will contact
you with a quote regarding delivery costs</font></td>
</tr>
</table>
<p> </td>
</tr>
</table>
</center>
</div>
<p> </p>
<p><font face="Verdana">
<input type="submit" value="Process Order" name="B1"></font></p>
<input type="hidden" name="UID" value="<%=session("mm_UserName")%>">
</form>
<p><font face="Verdana" size="2"><br>
</font></td>
</tr>
</table>
</center>
</div>
</body>
</html>
please help
|
|
|
|
ianb
Posts: 20
Joined: 5/8/2006
Status: offline
|
RE: seperate records for each item - 6/15/2006 9:42:09
Firstly, thank you for your response.
im not quite with you here.
the problem with that is the data is populated from a database, so i can only have one quantity.
but it duplicates depending how many items are ordered.
or am i missing something here?
| |
|
|
|
ianb
Posts: 20
Joined: 5/8/2006
Status: offline
|
RE: seperate records for each item - 6/15/2006 9:44:48
i have tried many shopping carts, but can seem to find one that suits me. I am almost finished with it except for this one issue.
| |
|
|
|
rdouglass
Posts: 9187
From: Biddeford, ME USA
Status: offline
|
RE: seperate records for each item - 6/15/2006 10:07:15
quote:
the problem with that is the data is populated from a database, so i can only have one quantity.
Yes, I do understand that. But you have to remember it is 1 quantity per item and the trick is to identify which item each quantity belongs to. And to do that you have to uniquely name each quantity field or all quantities will be in 1 field and not separated.
Does that make any sense?
EDIT: You'd need to do the same with other tiems as well other than quantites.
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
ianb
Posts: 20
Joined: 5/8/2006
Status: offline
|
RE: seperate records for each item - 6/15/2006 10:13:30
but i only have one quantity field
(removed super-huge pic - rdouglass)
< Message edited by rdouglass -- 6/15/2006 10:25:10 >
| |
|
|
|
rdouglass
Posts: 9187
From: Biddeford, ME USA
Status: offline
|
RE: seperate records for each item - 6/15/2006 10:15:13
OK. So they can only order 1 item?
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
ianb
Posts: 20
Joined: 5/8/2006
Status: offline
|
RE: seperate records for each item - 6/15/2006 10:19:23
http://pets4u.ihost4u.co.za/scart
can order as many items as they want
| |
|
|
|
rdouglass
Posts: 9187
From: Biddeford, ME USA
Status: offline
|
RE: seperate records for each item - 6/15/2006 10:24:26
So they can like order 1 of the first item and 3 of the second?
If so then you need separate quantity fields for each item. This is the key I'm trying to show you. Yes you only have 1 quantity per item but you want to have more than 1 item.
Please remember this is on the web form and *not* in the database.
You need to distinguish each quantity field (as well as each other field relating to each item in the cart) so they don't all 'mash' together.
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
rdouglass
Posts: 9187
From: Biddeford, ME USA
Status: offline
|
RE: seperate records for each item - 6/15/2006 11:50:08
To start with, can you sucessfully UPDATE 1 item? If so, can you post the code?
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
ianb
Posts: 20
Joined: 5/8/2006
Status: offline
|
RE: seperate records for each item - 6/15/2006 11:55:13
yes,
im not updating im inserting
this is the code that inserts:
!--#include file="../_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="insert into OrdersConfirmed (UID, quantity, product) values ( '::UID::', '::quantity::', '::product::')"
fp_sDefault="UID=&quantity=&product="
fp_sNoRecords="No records returned."
fp_sDataConn="scart"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&"
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=2
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<p>
<!--webbot bot="PurpleText" PREVIEW="inserts the order details" --></p>
<!--#include file="../_fpclass/fpdbrgn2.inc"-->
</body></html>
| |
|
|
|
rdouglass
Posts: 9187
From: Biddeford, ME USA
Status: offline
|
RE: seperate records for each item - 6/15/2006 12:26:23
What you have to do is somehow loop thru each line and grab the item parameters and then run the INSERT.
Did you read any of those examples in the search results I posted? There are at least 3 examples of this in the first dozen or so results. Please read those over closely.
You must, I repeat *must* somehow identify each individual item of each line as being separate and distinct items. Then you'd do something like this each time thru the loop:
<%
FOR i = 0 TO howManyLoopItems
...
myQuery = "insert into OrdersConfirmed (UID, quantity, product) values ( '::UID" & identifyer & "::', '::quantity" & identifyer & "::::', '::product" & identifyer & "::::')"
...
...
<%
fp_sQry= myQuery
fp_sNoRecords="No records returned."
fp_sDataConn="scart"
...
NEXT
%>
Something like that. The point is we need to loop thru each 'line' and insert it individually. The only way I know of to do that (and keep track of what goes with which) is to distinctly identify each field item.
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
ianb
Posts: 20
Joined: 5/8/2006
Status: offline
|
RE: seperate records for each item - 6/15/2006 12:40:19
yes, i thought i would need that somewhere.
but how do i identify, not knowing howmany items the person is going to order?
or am i on the wrong track here???
alteratavly, when i get the results in the database (in one record, all together)
is there a way i can display them in the correct format?
| |
|
|
|
rdouglass
Posts: 9187
From: Biddeford, ME USA
Status: offline
|
RE: seperate records for each item - 6/15/2006 12:54:13
Let's back up a little here.
I'm not sure how you have your DB organized but normally it's done something like this:
1. A table Customers has customer information with a CustID.
2. A table Orders has order information on it with an OrderID and a CustID field that is related to customer.
3. A table OrderItems has order items in it with quantities and ItemID's (from 4th table) and an OrderID related to orders as well as an OrderItemID.
4. A table Items with items and an ItemID.
So customer logs in and starts an order. An order is created in the Orders table with the customer's CustID.
They pick an item to add to their cart and it is added to the Order Items table with the ItemID and the OrderID relating to the item and the order respecitvely.
Now here is where I see the important part: When you show the cart with the items that have been selected and in the cart, then you can set the fields for each item distinguishable by the OrderItemID when you write the list.
Then you can pull out the OrderItemID from 1 field (a hidden field if you want) and then use that OrderItemID when you UPDATE quantities.
When you do an INSERT, you're just creating a new one however you should be checking to see if the item is already in the cart in which case you should be adding 1 quantity. (See why I'm suggesting gettign one already done?)
The issue is you need to somehow identify each line item in the cart and that each line should be a separate line in a distincrt "order items" table.
Does that make any more sense now?
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
ianb
Posts: 20
Joined: 5/8/2006
Status: offline
|
RE: seperate records for each item - 6/15/2006 13:07:12
please have a look at the cart
http://pets4u.ihost4u.co.za/scart
customer logs in
adds product and quantity to temporary table (itemsOrdered)
once he has completed adding all his products
then goes to checkout where it displays what he has put in the temporary table, plus some more options, shipping etc, and postage details.
it then takes all of these details and inserts it into another table (ordersconfirmed)
i do this so that the person cant go back at a later stage, and resubmit a confirmed order.
they can go and start a new one
| |
|
|
|
ianb
Posts: 20
Joined: 5/8/2006
Status: offline
|
RE: seperate records for each item - 6/15/2006 14:31:44
thank you for all of your help so far.
another alterative to this would be if there is a way to display the comma seperated records in the correct format
this would also work
| |
|
|
|
rdouglass
Posts: 9187
From: Biddeford, ME USA
Status: offline
|
RE: seperate records for each item - 6/15/2006 15:06:29
Yes it is an alternative. To separate a comma delimited string:
myArray = split(myString,",")
where myString is the list of items that are separated by commas and myArray will be an array of items addressable like:
myArray(x)
That help?
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
rdouglass
Posts: 9187
From: Biddeford, ME USA
Status: offline
|
RE: seperate records for each item - 6/15/2006 15:14:26
If I have this text in a field:
"a,b,d,f"
and want to show each one separately, I can use the split function like so:
<%
myString = "a,b,d,f"
'how you get the text into the variable will vary
myArray = split(myString,",")
'that will 'split' the string into an array
FOR i = 0 TO ubound(myArray)
'allows us to start a loop for each item in the array
Response.write(myArray(i) & "<br>")
NEXT
'Go to next item in the array
%>
Put that on an ASP page and browse to it. CHange the items in myString to whatever you want to split.
Is that what you had in mind?
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
ianb
Posts: 20
Joined: 5/8/2006
Status: offline
|
RE: seperate records for each item - 6/15/2006 15:38:27
ok this is what i have, dont know if ive got it all in the right place??
<!--#include file="_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'></div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM OrdersConfirmed"
fp_sDefault=""
fp_sNoRecords="No records returned."
fp_sDataConn="scart"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=3
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<p><b>ProdID:</b> <%mystring = FP_FieldVal(fp_rs,"ProdID")%></p>
<p><b>Quantity:</b> <%mystring1 = FP_FieldVal(fp_rs,"Quantity")%></p>
<p><b>Product:</b> <%mystring2 = FP_FieldVal(fp_rs,"Product")%></p>
<hr>
<%
myArray = split(myString,",")
myArray = split(myString1,",")
myArray = split(myString2,",")
FOR i = 0 TO ubound(myArray)
'allows us to start a loop for each item in the array
Response.write(myArray(i) & "<br>")
NEXT
%><!--#include file="_fpclass/fpdbrgn2.inc"-->
| |
|
|
|
rdouglass
Posts: 9187
From: Biddeford, ME USA
Status: offline
|
RE: seperate records for each item - 6/15/2006 16:21:21
quote:
myArray = split(myString,",")
myArray = split(myString1,",")
myArray = split(myString2,",")
FOR i = 0 TO ubound(myArray)
'allows us to start a loop for each item in the array
Response.write(myArray(i) & "<br>")
NEXT
Close. You'll probably have better luck doing it this way:
myArray = split(myString,",")
myArray1 = split(myString1,",")
myArray2 = split(myString2,",")
FOR i = 0 TO ubound(myArray)
'allows us to start a loop for each item in the array
Response.write(myArray(i) & " - " & myArray1(i) & " - " & myArray2(i) & "<br>")
NEXT
That make sense?
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
