% @LANGUAGE = "VBScript" %> <% Response.Buffer = True %> <% Randomize '---- CursorTypeEnum Values ---- Const adOpenForwardOnly = 0 Const adOpenKeyset = 1 Const adOpenDynamic = 2 Const adOpenStatic = 3 '---- LockTypeEnum Values ---- Const adLockReadOnly = 1 Const adLockPessimistic = 2 Const adLockOptimistic = 3 Const adLockBatchOptimistic = 4 Set boatnames = Server.CreateObject("ADODB.Connection") Set boatstories = Server.CreateObject("ADODB.Recordset") Set randomstories = Server.CreateObject("ADODB.Recordset") boatnames.Open "mgibn" randomstories.open "SELECT * FROM [stories]", boatnames, 1, 1 RandomPick = Int(ABS((RND(1) * RandomStories.RecordCount) + 1)) randomstories.MoveFirst RandomStories.Move RandomPick If Request("Submit") <> "" Then Set boatnames = Server.CreateObject("ADODB.Connection") Set boatstories = Server.CreateObject("ADODB.Recordset") boatnames.Open "mgibn" boatstories.open "SELECT * FROM [stories]", boatnames, adOpenKeyset, adLockOptimistic boatstories.AddNew boatstories("Name") = UCASE(Request("Name")) boatstories("Story") = Request("Story") boatstories.Update Set StoryCC = Server.CreateObject("JMail.SMTPMail") StoryCC.LazySend = True StoryCC.ServerAddress = "mail.marinegraphics.com; mail.thingk.net; mail.transfur.com; mail.tf-ring.com; mail.hotmail.com" StoryCC.AddRecipient "boatnames@marinegraphics.com" 'StoryCC.From = request("email:") StoryCC.Sender = "webmaster@vinylgraphics.com" 'StoryCC.FromName = Request("EMail") StoryCC.ReplyTo = Request("EMail") StoryCC.Subject = Request("Name") StoryCC.Priority = 1 StoryCC.Subject = "NEW BoatName STORY!!!" StoryCC.Body = Request("Name") & vbcrlf & vbcrlf _ & Request("Story") StoryCC.Execute Response.Redirect("boatnamingmadesimple.html") End If %>

|
|
What's your story? |
![]() |
Contact me to see if your story made it into the recent issue!
susan@marinegraphics.com October 20, 1997
© 1993-2009 Marine Graphics, Inc. |