Welcome to MSDN Blogs Sign in | Join | Help

AskaSQLGURU.com

I got the following from MVP Peter Ward, sounds like a cool initiative.

From: Peter Ward
Sent: Saturday, 9 June 2007 12:33 AM
To: Frank Arrigo
Subject: AskaSQLGURU.com

 

Hi Frank

 

I thought you might be interested in a new venture that I have recently founded with several other SQL Server ‘Gurus’ from around the world, AskaSQLGURU.com.

 

The concept of this free service is that if you have a SQL Server question simply Skype your question to askasqlguru and we will create a personalised screencast with an answer to your question.

 

You’ve got questions...we’ve got answers AskaSQLGURU.com

 

Regards

 

Peter Ward

WARDY IT Solutions Chief Technical Architect and MVP Windows Server System - SQL Server

WARDY IT Solutions – Specialising in building Microsoft SQL Server Solutions


- Do you attend the QLD SQL Server User Group, the best place to learn about SQL Server for Free?
- Have you subscribed to the WARDY IT Solutions Monthly SQL Server Newsletter? To subscribe send an e-mail to newsletter_add@wardyit.com

Technorati tags: , ,
Published Saturday, June 09, 2007 2:39 PM by frankarr
Filed under:

Comments

Saturday, June 09, 2007 1:09 AM by Whitee

# re: AskaSQLGURU.com

I have a problem posting an input field to another .asp page.  My code authenticates against an Access DB and that work, I just can't get it post to the next page.  Looking for assistance.  Here's my code:

Authentication Code:

<!--#include file="Connections/conn.asp" -->

<%

' *** Validate request to log in to this site.

MM_LoginAction = Request.ServerVariables("URL")

If Request.QueryString<>"" Then MM_LoginAction = MM_LoginAction + "?" + Server.HTMLEncode(Request.QueryString)

MM_valUsername=CStr(Request.Form("ClientID"))

If MM_valUsername <> "" Then

 MM_fldUserAuthorization=""

 MM_redirectLoginSuccess="survey_questions.asp"

 MM_redirectLoginFailed="login_fail.asp"

 MM_flag="ADODB.Recordset"

 set MM_rsUser = Server.CreateObject(MM_flag)

 MM_rsUser.ActiveConnection = MM_conn_STRING

 MM_rsUser.Source = "SELECT ClientID"

 If MM_fldUserAuthorization <> "" Then MM_rsUser.Source = MM_rsUser.Source & "," & MM_fldUserAuthorization

 MM_rsUser.Source = MM_rsUser.Source & " FROM tblclientinfo WHERE ClientID='" & Replace(MM_valUsername,"'","''") & "'"

 MM_rsUser.CursorType = 0

 MM_rsUser.CursorLocation = 2

 MM_rsUser.LockType = 3

 MM_rsUser.Open

 If Not MM_rsUser.EOF Or Not MM_rsUser.BOF Then

   ' username and password match - this is a valid user

   Session("MM_Username") = MM_valUsername

   If (MM_fldUserAuthorization <> "") Then

     Session("MM_UserAuthorization") = CStr(MM_rsUser.Fields.Item(MM_fldUserAuthorization).Value)

   Else

     Session("MM_UserAuthorization") = ""

   End If

   if CStr(Request.QueryString("accessdenied")) <> "" And false Then

     MM_redirectLoginSuccess = Request.QueryString("accessdenied")

   End If

   MM_rsUser.Close

   Response.Redirect(MM_redirectLoginSuccess)

 End If

 MM_rsUser.Close

 Response.Redirect(MM_redirectLoginFailed)

End If

%>

Form:

<form action="<%=MM_LoginAction%>" name="ClientID" method="post">                Client Account Number:

<input name="ClientID" type="text" size="15" maxlength="15" />

<option>

<% = Request.Form("ClientID") %>

</option>

<input type="submit" name="Submit" value="Submit" />

</form>

Next Page Form:

<form method="POST" name="survey" action="survey_finish.asp">

      <input type="hidden" value="<% = Request.Form("ClientID") %>" name="ClientID">

Where I want to displayed:

<td class="black11b"><% = Request.Form("ClientID") %></td>

Thanks for you help.

Monday, June 11, 2007 12:53 PM by OffBeatMammal

# Ask a SQL Guru

I know a little bit about making SQL work for a dynamic website, but I&#39;m no world renowned expert

New Comments to this post are disabled
 
Page view tracker