October 7, 2008 01:57pm pdt

1. hielo 864,231
2. b0lsc0tt 283,628
3. angelIII 178,470
4. dosth 168,195
5. _Stilgar_ 141,814
6. neeraj523 129,917
7. cedlinx 94,700
8. samic400 93,087
9. R_Harrison 73,020
10. CyrexCor... 65,020
11. ryancys 57,163
12. cyberweb... 53,815
13. the_crazed 52,314
14. pratima_... 52,072
15. GreenGho... 51,949
16. kevp75 51,006
17. asvforce 49,032
18. gawai 47,643
19. sybe 44,840
20. golfDoctor 44,597
21. chapmandew 43,730
22. deathtospam 42,350
23. Badotz 42,140
24. CCongdon 41,180
25. jitganguly 39,482

1. fritz_the... 3,970,430
2. alorentz 1,929,293
3. amit_g 1,328,388
4. ap_sajith 921,034
5. hongjun 914,936
6. WMIF 899,748
7. hielo 894,041
8. kevp75 859,933
9. b0lsc0tt 797,762
10. jitganguly 780,862
11. peh803 684,060
12. angelIII 681,305
13. acperkins 654,964
14. Silvers5 625,555
15. GaryC123 576,095
16. carl_tawn 572,230
17. sybe 565,215
18. ryancys 514,650
19. neeraj523 514,398
20. SquareHead 513,787
21. deighc 466,721
22. apresto 450,527
23. golfDoctor 447,243
24. gladxml 429,512
25. mgfranz 418,620

05.09.2008 at 01:39PM PDT, ID: 23390760

	[x] Attachment Details

ASP Record Set Question

Asked by sarniscool in Active Server Pages (ASP)

I have a quick question about record sets. In the code sniplet I have an example snipplet from my application. My question is in the line:

sql = "SELECT * FROM tbl"

If I change it to :

sql = "SELECT * FROM tbl where id = 1"

It still works. It doesn't matter if I select everything from the database or not, because it still inserts "NEW ROW." My thinking is that if I change the sql statement to "sql = "SELECT * FROM tbl where id = 1"" it would have wiped out my database except for ID = 1 and and the new row. Because I thought the line takes the database stores it in the record set. Adds a new row to the record set and then adds the whole record set back into the database.

Did I miss something?

Thanks

Start Free Trial

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:

           
           
             Function OpenRecordset(strSQLQuery, ConnStr)					
	Set defaultRS = Server.CreateObject("ADODB.Recordset")
	defaultRS.Open strSQLQuery, ConnStr, 3, 3
	Set OpenRecordset = defaultRS
End Function
 
set dbConn = Server.CreateObject ("ADODB.Connection")
 
dbConn.Open "Provider=SQLOLEDB.1;Initial Catalog=*****;Data Source=***;User ID=****;Password=******"
 
 
sql = "SELECT * FROM tbl"
 
set addRS = OpenRecordset(sql, dbConn)
 
addRS("comments") = "NEW ROW"
addRS.close
Set addRS = Nothing

           
         

Keywords: ASP Record Set Question

	Title
1	How to read the data in a tbl and save …
2	Concatenating rows in SQL
3	SQL Update statement in ASP page
4	Complex SQL Statement
5	Cant update record in asp
6	Select 3 random rows from dataset in …

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

ASP Record Set Question

Asked by sarniscool in Active Server Pages (ASP)

About this solution