Share via

AskaSQLGURU.com

  • Article

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: AskASQLGuru, Peter Ward, WardyIT

Comments

  • Anonymous
    June 08, 2007
    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.

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