Advanced Search

Return to Snippet

Revision: 1530
at October 17, 2006 11:37 by jgmutza
Updated Code 
dim MyColumn3Value: MyColumn3Value = "something stringy"
...
dim sql: sql = "select Column1, Column2 from MyFavoriteTable where Column3 = ?"
set rs = connection.Execute(sql, Array(MyColumn3Value))

Revision: 1529
at October 17, 2006 11:34 by jgmutza
Initial Code 
dim MyColumn3Value: MyColumn3Value = "something stringy"
...
dim sql: sql = "select Column1, Column2 from MyFavoriteTable where Column3 = ?"
...
set rs = connection.Execute(sql, Array(MyColumn3Value))<br />
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
Parameter markers are Da Bomb!

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Using Parameterized Statements

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
ASP