|
Hi,
I have a MS access database of product's table namely
with fields imagefile, product_id, name, cost and 4
different products added.
I created a table 2 rows 2 cols in products.aspx, i have
the database connected, datasets up and i wish to display
the 4 products into this 2 row 2 col table i created, how
is that possible?
Earlier i setup'd a datagrid and managed to list all of
the products in one table but i can't do anything
to it and it is not the table i want.
How do i pull individual product id and its other info
in each of my cols in my table rows..
Thanks,
Josh
|
|
|
|
|
What you can do is to create a repeated region which loops through the dataset adding the appropriate code.
Go to Insert -> Application Objects - > Repeating region.
You can set the number of repeats for this region. Also, you can set a datasource for it. This means that each time the region repeats it will navigate to the next row in your table.
Will look similar to below
Ie ASP:Repeater runat="server" DataSource='<%# MyDsTable.DefaultView %>
Within this region, place the code that you'd like to see repeated.
<br />
Ie. <tr><td> <%# MyDsTable.FieldValue("Field1", Container) %></td><br />
<td> <%# MyDsTable.FieldValue("Field2", Container) %></td><br />
</tr><br />
This will create a new row for your table for each record in the dataset for however many times you repeat that region.
Make sense?
_____________________
Don't take out the Magic Pen,
Don't draw on the Infinity Board
- Neil Young
|
|
|
|
|
Thanks! help'd a lot =)
I managed to repeat my first 4 items as below.
id product name
-- --
OS1001 Microsoft Windows XP Home
OS1002 Microsoft Windows XP Pro
OS1003 Microsoft Windows 2000
OS1004 Microsoft Windows ME
How do i choose, say I do not want OS1001-1004, i
would like to list the 4th - 8th item in the same table?
basically to choose what to list.. instead of having
it pick first 4 items fr the table.
Where can i get samples or tutorials for this exact
method to use dreamweaver datasets?
Please help me, thanks.
Thanks.
|
|
|
|
|
Good day to all,
I was hoping someone could help me with this problem, as i have tried all the links on Microsoft.com and I am now in desperate need of a resolution.
Here goes,
Recently we have upgraded our web server from IIS 5.0 to 6.0 and installed our ASP application.
In doing this the application has ceased to work, this is due to the session variables being lost between the logon page and the frameset page.
So far we have discovered:
The sessionID remains live, and stays the same and can written to the screen at any point.
The sessions set in Global.asa are present through-out the redirections and can be written to the screen at any point.
The sessions set on the logon page are lost as soon as the page is re-directed. Meaning the user is logged straight back out.
Any suggestions/ideas/resolutions greatly appreciated.
Thanks
Purple
"If i was king, cigarettes would be free."
|
|
|
|
|
Howdy,
I have found this also at times with certain applications.
What I have found is that if a redirect is done the variables are lost. When I have changed my url's to anchor exactly where they are destined to go, my variables have remained.
Strange, I know.
Let me know if this helps,
Kutz
_____________________
Don't take out the Magic Pen,
Don't draw on the Infinity Board
- Neil Young
|
|
|
|
|
Unfortunately that did not help but thanks for the reply.
However, we did resolve the problem.
What we discovered was that the directories in the home directory also have to be added as virtual directories unlike iis 5.0 which must assume this.
As soon as we added the directories inside the root as vds and removed the application it all came together and everything works fine.
Lovely Jubbly....
"If i was king cigarettes would be free."
|
|
|
|
|
The most likely cause of this problem is if the "Maximum number of worker processes" value (on the Performance page on the properties of the AppPool) is set to a value other than 1.
http://msdn.microsoft.com/library/en-us/cpguide/html/cpconperformanceapplicationpoolsettings.asp[^]
Since ASP session state is stored in-process, each worker process will have its own copy of the session state. Subsequent requests from the same client will not necessarily be routed back to the same worker process, so you will either lose your session state, or see an out-of-date copy.
Variables set in the Session_Init section of Global.asa will be re-initialized if the current process doesn't have a copy of the session, which would explain why these variables are always available.
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
|
|
|
|
|
i have deployed an application using weblogic 5.1 with service pack 9.
i have tried install service provided in the weblogic folders but it fails..
my requirement is , i have run my weblogic as a service! seniors help please.....
waiting for ur advice
|
|
|
|
|
hi guys,
I am doing an ASP page using javascript not VBscript linked to an access database. I have a table within the database (tblProduct) where i have
the fields ProductName, Price, description etc... Displaying the records on the website is simple, however, it will be like a shopping cart, where every
record is displayed and a checkbox next to it for the user to check if he is interested in the product. The problem is the user can select more than one
product, i.e. check more than one checkbox and a record of what he has selected needs to go into the database for example
UserID ProductID Date
0001 034 12/12/2004
0001 035 12/12/2004
I could not find any code (in javascript) to help me assign a value for the checkbox that is linked to the product and i do not know how to call it up, so
i can insert it to the database.
Since the records with the checkboxes will be produced depending on how many products meet the user's search, for example the user searches for products that
are under $200 and it will search the database to select all products that are under $200 and display them on the website, the user will then choose which
products to put in his shopping cart, which he can come back to any time.
I would appreciate if someone points me in the right direction with a link or help on here would be even better.
thank you
|
|
|
|
|
You can display the data like this:
response.Write "<td><input name='chcProduct' type='checkbox' value='" & rs("ProductID") & "'></td>"
It is in table called detail, so
row_count = detail.rows.length;<br />
if(row_count>1){<br />
chcCount = Completion.chcProduct.length;<br />
if(chcCount==undefined)<br />
{<br />
ProductID += Completion.chcProduct.value + ",";<br />
}<br />
else<br />
{<br />
for (i = 1; i <= chcCount ; i++){<br />
if (Completion.chcProduct[i-1].checked){<br />
ProductID += Completion.chcProduct[i-1].value + ",";<br />
<br />
}<br />
}<br />
}<br />
<br />
}
The result is you will get ProductID seperated by ",". When you save, split the ProductID, which will get you every ProductID selected.
<italic>Work hard, Work effectively and a bit of luck is the key to success.
|
|
|
|
|
Is there a limit on the number of applications that i can create on IIS 6.0??
|
|
|
|
|
I've been getting a problem with asp error 0113
I know you can change the Server.ScriptTimeout but i was wondering if theres a difference when using these two drivers and if this could be also making my code get errors??? heres the codes for two simple pages which is best to use?
<%@LANGUAGE=VBScript%><br />
<%<br />
Dim adoCon <br />
Dim rs <br />
Dim strSQL <br />
<br />
Set adoCon = Server.CreateObject("ADODB.Connection")<br />
<br />
adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("jet.mdb")<br />
<br />
Set rs = Server.CreateObject("ADODB.Recordset")<br />
<br />
strSQL = "SELECT jet.* FROM jet"<br />
<br />
rs.Open strSQL, adoCon<br />
%><br />
<br />
<br />
<% = rs("Text") %><br />
<br />
<br />
<%<br />
rs.Close<br />
Set rs = Nothing<br />
adoCon.Close<br />
Set adoCon = Nothing<br />
%>
or
<%@LANGUAGE=VBScript%><br />
<%<br />
dim Conn, sConnection, rs<br />
<br />
<br />
Set Conn = Server.CreateObject("ADODB.Connection")<br />
sConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" & _<br />
"Data Source=" & Server.MapPath("jet.mdb") & ";" & _<br />
"Persist Security Info=True"<br />
Conn.Open(sConnection)<br />
<br />
set rs = conn.Execute("SELECT * FROM jet")<br />
%><br />
<br />
<br />
<% = rs("Text")%><br />
<br />
<br />
<%<br />
rs.close<br />
Set rs = Nothing<br />
Conn.close<br />
Set Conn = Nothing<br />
%><br />
Thanks
|
|
|
|
|
mjay2004 wrote:
I've been getting a problem with asp error 0113
I know you can change the Server.ScriptTimeout but i was wondering if theres a difference when using these two drivers and if this could be also making my code get errors??? heres the codes for two simple pages which is best to use?
I've used both at different times and have had some really strange errors while using the {Microsoft Access Driver} in the connection string, as far as what's different I don't know. I've had the best results using the JET connection engine string over the *.mdb.
Just my $00.2
Nino
|
|
|
|
|
Hi all, i'm looking to create some forums on a website and i was hoping someone could reccomend a few for me to have a look at. I want to do it in ASP.Net if at all possible as i'm a C# developer.
Kev
|
|
|
|
|
i don't know of any asp.net forums, but i've used one called phpBB before. it's quite easy to set up, there are some cool skins and mods for it, and although it uses php, i don't recall actually needing to worry about looking at code.
as is the case with all software, there have been some bugs and holes in the past, so make sure you get the latest version...
i'm not sure what the url is, but i think it's http://www.phpbb.com/[^].
--
Raoul Snyman
Saturn Laboratories
e-mail: raoul.snyman@saturnlaboratories.co.za
web: http://www.saturnlaboratories.co.za/
blog: http://blog.saturnlaboratories.co.za/
linux user: #333298
|
|
|
|
|
Trouble connecting to the database using perl and CGI.
|
|
|
|
|
Which DBI module are you using...provide some of your code.
|
|
|
|
|
Hi all
When leaving a page, I want to have a popup message to make sure whether you want to leave the page. Could anyone help me out to write this in javascript or vbsript, please?
Thanks very much!
GoldenStar
|
|
|
|
|
"An education isn't how much you have committed to memory, or even how much you know. It's being able to differentiate between what you do know and what you don't." - Anatole France
|
|
|
|
|
Is it possible to take the values from two pages(and two forms of course) and combine them on one page? I tried that but the values cannot be there at the same time--- they appeared one by one. I need them appear on the same page at the same time so that I can display the combined value on the same page.
Thanks.
|
|
|
|
|
If nothing else works, here is a realy dirty way of doing it: Make a page with three frames, lets say 3 rows. The first row (frame1) spans all available space and the last two take up 1 pixel. In the last two rows (frame2 and frame3), place the pages with the two forms.
Use javascript to find the values of the forms. I believe the dom for this is something like frame2.document.form1.total.value (depending on your form name and input box name). This will allow you to grab those totals and take them into frame1.
Hopefully, you will find a better way to do it, because my way kinda sucks.
|
|
|
|
|
How do I find the caret position of a ContentEditable DIV ?
|
|
|
|
|
I have some javascript code in my page that calls the document.getElementById method. This usually works fine however in IE 6, after I have downloaded a file using the File Download dialog, I get an unspecified error. Whenever I try to access document this error occurs but only when the page is within a frame. I have tried using window.frames["frameMain"].document but that causes an unspecified error as well.
Does anyone have any clues as to what is going on.
SuzyB
If I had a better memory I would remember more.
|
|
|
|
|
could you post some of the code? Also, is you javascript in a .js file, or inside of the html file?
|
|
|
|
|
The javascript is in a js file but I created a small test with the javascript in the page and it didn't make any difference.
I think it may be due to the fact that the download happens on a postback. In my click event for my button I set the following properties of the response then read the file and BinaryWrite the file to it.
HttpContext.Current.Response.Buffer = true;
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.Charset = "";
HttpContext.Current.Response.ContentType = ContentType;
HttpContext.Current.Response.AddHeader( "content-disposition", "attachment; filename=" + DownloadFileName );
Simply adding an anchor that points to the file doesn't cause the error however the file is created dynamically so thats not really an option.
SuzyB
If I had a better memory I would remember more.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
