|
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.
|
|
|
|
|
Hmmm...I'm stumped. At this point, I'd have to work with it hands-on to even know what other questions to ask. Sorry.
|
|
|
|
|
Hi i've created a coding using javascript with ur help.. but when i run this code.."txtval" function does'nt work properly...plzz guide me.. if i enter a number it accepts and goes to the second page.. which i don't want. text box shld accept only the characters.
==> "pag1.html"
function txtval()
{
numberCount=0
for(i=0;i<document.myform.myname.value.length;i++){
j=i+1
mychar=document.myform.myname.value.substring(i,j)
if((0 <= mychar)&&(mychar <= 9))
{
numberCount++;
}
}
if((numberCount == 0)&&(document.myform.myname.value.length > 0)){
document.myform.submit()
}else{
alert('please check your form')
}
}
function openwin()
{
window.open(pag2.html)
window.action.reload()
}
User name:
==> "pag2.html"
function closeWin(){
window.close()
}
function timer(){
timerID = setTimeout("closeWin()",3000)
}
timer();
BlueWhale is the World's Largest animal
Yes
No
BhuvanaSathish
|
|
|
|
|
BhuvanaSathish wrote:
if((0 <= mychar)&&(mychar <= 9))
In this line you're comparing a string type to an integer type. The value of numberCount will never increment. Try
if(('0' <= mychar)&&(mychar <= '9'))
instead.
"If it's Snowbird season, why can't we shoot them?" - Overheard in a bar in Bullhead City
|
|
|
|
|
Hi.. Plz guide me if i could connect Oracle with Javascript?? If so how can i write the codings?? Plzz suggest me..
THank you
BhuvanaSathish
|
|
|
|
|
On what level can this fail to be a spectacularly bad idea ? You're running jscript on the server side ? And coding the DB access directly into the page script ?
Christian
I have several lifelong friends that are New Yorkers but I have always gravitated toward the weirdo's. - Richard Stringer
|
|
|
|
|
You can't program a database in javascript. You can use javascript in the web page to make the user-experience better, but the data handling needs to be done on the back end with something like asp, .net, php, perl, etc.
|
|
|
|
|
I have an order form in ASP. One order can have many products. With so many products it's impossible to put that on a combo. So the user must type product code. That's OK for the user. How to validate so that the user didn't enter two same products on one order. I tried using functions which access Array. So when the user chooses a product it will be sent to the Array, and so on. Is there a better way for this? I think this is dangerous because I have to declare an Array and delete it repeatedly. Thanks.
<italic>Work hard, Work effectively and a bit of luck is the key to success.
|
|
|
|
|
Is it possible to change the approach of how the user selects an item? If there are too many to put in one list, perhaps you can drill down through categories and sub-categories. Take a look at a website like home depot. They sell thousands of items, but they don't list all items on any one page. You have to go into a department, select a category inside that department, and there might be sub-category after sub-category (nearly infinately in terms of possibility) until you find the product itself.
|
|
|
|
|
Thanks. I can't drilll through categories and sub-categories. All the same type. I'm planning to build a class for the list.
<italic>Work hard, Work effectively and a bit of luck is the key to success.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
