|
thks for ansver. i convert sql query * to all tag. now problem is not
--------------------------------------------------------------------
'******************************************
'*** Read in user details from database ***
'******************************************
'Intialise the strSQL variable with an SQL string to open a record set for the Author table
strSQL = "SELECT " & strDbTable & "Author.* " & _
"FROM " & strDbTable & "Author" & strRowLock & " " & _
"WHERE " & strDbTable & "Author.Author_ID=" & lngUserProfileID & ";"
'Set the cursor type property of the record set to Dynamic so we can navigate through the record set
rsCommon.CursorType = 2
'Set the Lock Type for the records so that the record set is only locked when it is updated
rsCommon.LockType = 3
'Open the author table
rsCommon.Open strSQL, adoCon
convert to :
'******************************************
'*** Read in user details from database ***
'******************************************
'Intialise the strSQL variable with an SQL string to open a record set for the Author table
strSQL = "SELECT tblauthor.Author_ID, tblauthor.Group_ID, tblauthor.Username, tblauthor.Real_name, tblauthor.User_code, tblauthor.Password, tblauthor.Salt, tblauthor.Author_email, tblauthor.Homepage, tblauthor.Location, tblauthor.MSN, tblauthor.Yahoo, tblauthor.ICQ, tblauthor.AIM, tblauthor.Occupation, tblauthor.Interests, tblauthor.DOB, tblauthor.Signature, tblauthor.No_of_posts, tblauthor.No_of_PM, tblauthor.Join_date, tblauthor.Avatar, tblauthor.Avatar_title, tblauthor.Last_visit, tblauthor.Time_offset, tblauthor.Time_offset_hours, tblauthor.Date_format, tblauthor.Show_email, tblauthor.Attach_signature, tblauthor.Active, tblauthor.Rich_editor, tblauthor.Reply_notify, tblauthor.PM_notify, tblauthor.Skype, tblauthor.Login_attempt, tblauthor.Banned, tblauthor.Info " &_
"FROM " & strDbTable & "Author" & strRowLock & " " & _
"WHERE " & strDbTable & "Author.Author_ID=" & lngUserProfileID & ";"
'Set the cursor type property of the record set to Dynamic so we can navigate through the record set
rsCommon.CursorType = 2
'Set the Lock Type for the records so that the record set is only locked when it is updated
rsCommon.LockType = 3
'Open the author table
rsCommon.Open strSQL, adoCon
-------------
Response.write "Asp"
Document.write("JavaScript")
Echo("Php")
WriteIn('Pascal-Delphi')
Printf("C")
Mail & GTalk : BeyazSeytan@gmail.com
|