%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <% response.buffer = true ' check for an abacci cookie if session("uid") = "" then If Request.Cookies("abaccibooks") <> "" Then ' get this user's previous session uid session("uid") = Request.Cookies("abaccibooks")("uid") else ' new user, create a new cookie for them session("uid") = cstr(cdbl(cstr(year(now)) & cstr(month(now)) & cstr(day(now)) & cstr(timer())) * 100) response.Cookies("abaccibooks").expires = Now() + 90 response.Cookies("abaccibooks")("uid") = session("uid") End if end if Dim cmdListCount__list_ID cmdListCount__list_ID = "0" if(session("uid") <> "") then cmdListCount__list_ID = session("uid") %> <% Dim rsAuthor__MMColParam rsAuthor__MMColParam = "39" If (Request.QueryString("authorID") <> "") Then rsAuthor__MMColParam = Request.QueryString("authorID") End If %> <% Dim rsAuthor Dim rsAuthor_numRows Dim authorname dim commapos set cmBookAuthor = Server.CreateObject("ADODB.Command") cmBookAuthor.ActiveConnection = MM_cnBooks_STRING cmBookAuthor.CommandText = "dbo.spCwcAuthorsBooks" cmBookAuthor.CommandType = 4 cmBookAuthor.CommandTimeout = 0 cmBookAuthor.Prepared = true cmBookAuthor.Parameters.Append cmBookAuthor.CreateParameter("@RETURN_VALUE", 3, 4) cmBookAuthor.Parameters.Append cmBookAuthor.CreateParameter("@authorID", 200, 1,40,rsAuthor__MMColParam) set rsAuthor = cmBookAuthor.Execute if rsAuthor.eof then response.Redirect("searchplus.asp?author=yes") end if commapos = instr(rsAuthor.Fields.Item("authorName").Value,",") if commapos > 0 then authorname = mid(rsAuthor.Fields.Item("authorName").Value, commapos + 1) & " " & left(rsAuthor.Fields.Item("authorName").Value, commapos - 1) else authorname = rsAuthor.Fields.Item("authorName").Value end if rsAuthor_numRows = 0 Dim rsMisspell__MMColParam rsMisspell__MMColParam = "1" If (Request.QueryString("misspellID") <> "") Then rsMisspell__MMColParam = Request.QueryString("misspellID") End If Dim rsMisspell Dim rsMisspell_numRows On Error Resume Next set cmdMisspell = Server.CreateObject("ADODB.Command") cmdMisspell.ActiveConnection = MM_cnBooks_STRING cmdMisspell.CommandText = "dbo.spCwcMisspellAuthor" cmdMisspell.Parameters.Append cmdMisspell.CreateParameter("@RETURN_VALUE", 3, 4) cmdMisspell.Parameters.Append cmdMisspell.CreateParameter("@misspellID", 200, 1,40,rsMisspell__MMColParam) cmdMisspell.CommandType = 4 cmdMisspell.CommandTimeout = 0 cmdMisspell.Prepared = true set rsMisspell = cmdMisspell.Execute if rsMisspell.eof then response.redirect("authorDetails.asp?authorID=" & rsAuthor__MMColParam) end if %><% Dim rsEbook__MMColParam rsEbook__MMColParam = rsAuthor.Fields.Item("authorName").Value If (Request("MM_EmptyValue") <> "") Then rsEbook__MMColParam = Request("MM_EmptyValue") End If %> <% Dim rsComment Dim rsComment_numRows cmBookAuthor.CommandText = "dbo.spCwcAuthorComments" set rsComment = cmBookAuthor.Execute rsComment_numRows = 0 %> <% Dim rsCategories Dim rsCategories_numRows cmBookAuthor.CommandText = "dbo.spCwcCategories" set rsCategories = cmBookAuthor.Execute rsCategories_numRows = 0 %> <% Dim Repeat1__numRows Dim Repeat1__index Repeat1__numRows = -1 Repeat1__index = 0 rsAuthor_numRows = rsAuthor_numRows + Repeat1__numRows %> <% Dim Repeat3__numRows Dim Repeat3__index Repeat3__numRows = -1 Repeat3__index = 0 rsCategories_numRows = rsCategories_numRows + Repeat3__numRows %> <% Dim Repeat2__numRows Dim Repeat2__index Repeat2__numRows = -1 Repeat2__index = 0 rsComment_numRows = rsComment_numRows + Repeat2__numRows %> <% Dim rsABCD__MMColParam rsABCD__MMColParam = rsAuthor.Fields.Item("authorName").Value %> <% Dim rsABCD Dim rsABCD_numRows Set rsABCD = Server.CreateObject("ADODB.Recordset") rsABCD.ActiveConnection = MM_cnBooks_STRING rsABCD.Source = "SELECT top 1 authorid FROM dbo.abCDauthor WHERE authorname = '" + Replace(rsABCD__MMColParam, "'", "''") + "'" rsABCD.CursorType = 0 rsABCD.CursorLocation = 2 rsABCD.LockType = 1 rsABCD.Open() rsABCD_numRows = 0 %>
|
Abacci > Books >
">Authors
> <%=authorname%> |
|||||||
|
||||||||
|
<% if session("supervisor") = "true" then %> ">Edit Name | ">Delete Name | ">Add book <% end if %>
<% While ((Repeat2__numRows <> 0) AND (NOT rsComment.EOF)) %> <%=replace(replace(rsComment.Fields.Item("comment").Value,rsMisspell.Fields.Item("correctWord").Value,rsMisspell.Fields.Item("misspell").Value),"href=" & chr(34) & "detail.asp", "href=" & chr(34) & "page/detail.asp")%> <% Repeat2__index=Repeat2__index+1 Repeat2__numRows=Repeat2__numRows-1 rsComment.MoveNext() Wend %> <% end if %> <% rsComment.Close() Set rsComment = Nothing dim rsabcdfound %> <% if not rsABCD.eof then rsabcdfound = true %> <% else rsabcdfound = false %>
|
||||||||
| |
<% Dim rsEbook Dim rsEbook_numRows Set rsEbook = Server.CreateObject("ADODB.Recordset") rsEbook.ActiveConnection = MM_cnBooks_STRING rsEbook.Source = "SELECT top 1 * FROM dbo.cwcUvAuthors WHERE authorname = '" + Replace(rsEbook__MMColParam, "'", "''") + "'" rsEbook.CursorType = 0 rsEbook.CursorLocation = 2 rsEbook.LockType = 1 rsEbook.Open() rsEbook_numRows = 0 %> <% if not rsEbook.eof then %> Note: You can find Microsoft Reader format works by <%=authorname%> at " target="_blank">Abacci eBooks <% end if %> <% rsEbook.Close() Set rsEbook = Nothing %>
|
<%
' build the amazon book list
dim objHTTP
dim objXML
On Error Resume Next
'set objHTTP = Server.CreateObject("Microsoft.XMLHTTP")
set objHTTP = Server.CreateObject("MSXML2.ServerXMLHTTP")
' szGetString = rsBook.Fields.Item("amazonString").Value
'szGetString = "http://xml.amazon.com/onca/xml2?t=coverwave-20&dev-t=DEX7DQTIVJGCS&KeywordSearch=" & replace(trim(authorname)," ","+") & "&mode=books&type=heavy&page=1&sort=+pmrank&f=xml"
szGetString = rsAuthor.Fields.Item("amazonString").Value
objHTTP.open "GET", szGetString, true
objHTTP.Send
'Wait for up to 3 seconds if we've not gotten the data yet
If objHTTP.readyState <> 4 then
objHTTP.waitForResponse 3
End If
If (objHTTP.readyState <> 4) Or (objHTTP.Status <> 200) Then
'Abort the XMLHttp request
objHTTP.Abort
'strData = "Problem communicating with remote server..."
Else
Set objXML = objHTTP.ResponseXML
%>
|
|||||||||||||
Links for <%=authorName%>
<%
Dim rsLinks
Dim rsLinks_numRows
cmBookAuthor.CommandText = "dbo.spCwcLinks"
set rsLinks = cmBookAuthor.Execute
rsLinks_numRows = 0
%> <% if NOT rsLinks.EOF then %>
Suggest
a link for <%=authorName%>
Note: at Abacci the primary listing for
<%=authorname%> is: <%=realauthorname%> |
|||||||||||||||
Home | Authors | Titles | Categories | Your List | FAQ | <% if session("username") <> "" then%> Log Out | Your Account <% else %> Login <% end if %> | Contact Us | Site Map
Site Design: Megalong Multimedia