|
error message is : Login Faild!
the problem is I can connect from my pc , but when I upload the site it`s impossible...!
|
|
|
|
|
Where is the database server located?
---
b { font-weight: normal; }
|
|
|
|
|
I am not sure why I am getting this error if I have included: "IF NOT GOSSearchRS.BOF AND GOSSearchRS.EOF THEN". I hate to include the whole code but it may prove necessasry to get a response. It runs OK when I submit an empty value but if I search for something that's not in the database I get the error. See Error and Source Code Below.
Error Type:
ADODB.Recordset (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/gregstore/GregStoreMPSearchPage.asp, line 117
Source Code:
<!-- #INCLUDE FILE="adovbs.inc" -->
<!-- The file above is need for the usage of cursors used with retrieving the recordset. -->
<%
'Get Search Phrase
SearchFor = TRIM( Request( "searchfor" ) )
'Open database connection
Set dbCon = Server.CreateObject( "ADODB.Connection" )
dbCon.Open "GregStore"
%>
<HTML>
<HEAD><TITLE>Welcome to Greg's Online Store - Search </TITLE></HEAD>
<body link ="#ff4040" vtext="lightred" bgcolor="White">
<center>
<table width=640 border=0 cellspacing=0 cellpadding=0>
<tr>
<td bgcolor="lightblue">
<img src="belizeflag.gif">
<font size="5"><b>Welcome to Greg's Online Store!!</b>
</td>
<td align = right valign = "bottom">
<a href="cart.asp">Shopping Cart </a>
|
<a href = "account.asp"> Account </a>
</td>
</tr>
<tr>
<td colspan=2>
<hr width = "640" >
</td>
</tr>
</table>
<table width = 640 border=0 bgcolor="Azure" cellpadding=0 cellspacing=0>
<tr> <td valign = "top">
<table border=0 cellpadding=0 cellspacing=0>
<tr> <td valign = "bottom" bgcolor= "pink">
<img src="search.gif" vspace=0 border=0></td>
</tr>
<tr>
<td>
<table width = "200" border=1 cellpadding=4 cellspacing=0 bgcolor="lightyellow">
<tr>
<td>
<FORM METHOD="POST" ACTION = "GregStoreMPSearchPage.asp">
<input name = "searchfor" size="15">
<input type = "submit" value = "Search">
</form>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td valign="bottom">
<img src = "Categories.gif" vspace=0 border=0></td>
</tr>
<tr>
<td>
<table width="200" cellpadding=4 cellspacing=0 bgcolor="lightyellow" border=1>
<tr>
<td>
<font size="3"><b>
<!-- #INCLUDE FILE="GregStoreProductCategory.asp" -->
</b></font>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td><td valign="top">
<%
'Get The curent Page
pg = TRIM(Request( "pg" ))
IF pg = "" THEN pg = 1
SET GOSSearchRS = Server.CreateObject( "ADODB.Recordset" )
GOSSearchRS.ActiveConnection = dbCon
GOSSearchRS.CursorType = adOpenStatic
GOSSearchRS.PageSize = 5
'SQL Query String
sqlString = "SELECT product_id, product_picture, product_name, product_briefdesc " &_
"FROM Products " &_
"WHERE product_status = 1 " &_
"AND (product_name LIKE '%" & SearchFor & "%' " &_
"OR product_briefdesc LIKE '%" & SearchFor &"%' ) " &_
"ORDER BY product_name "
GOSSearchRS.OPEN sqlString
GOSSearchRS.AbsolutePage = pg
IF NOT GOSSearchRS.BOF AND GOSSearchRS.EOF THEN
%>
<table width="350" cellpadding=5 cellspacing=0 border=0>
<tr>
<td colspan=2>
<font size="3" color="darkblue">
<b>Search Results:</b>
</font>
</td>
</tr>
<% WHILE NOT GOSSearchRS.EOF AND rowCount < GOSSearchRS.PageSize
rowCount = rowCount + 1 %>
<tr>
<td>
<% IF GOSSearchRS( "product_picture" ) <> "?????" THEN %>
<IMG SRC = "<%=GOSSearchRS( "product_picture" ) %>"
HSPACE=4 VSPACE=4 BORDER=4 align="center">
<% END IF %>
</td>
<td>
<a href="GregStoreProduct.asp?pid=<%=GOSSearchRS( "product_id" )%>" >
<b><%=GOSSearchRS( "product_name" )%></b></a>
<br><%=GOSSearchRS( "product_briefdesc" )%>
<br><a href= "GregStoreProduct.asp?pid=<%=GOSSearchRS( "product_id" )%>" >
get more information</a>
</td>
</tr>
<tr>
<td colspan=2 align="center">
</td>
</tr>
<%
GOSSearchRS.MoveNext
WEND
%>
</table>
<%
IF GOSSearchRS.PageCount > 1 THEN
%>
<font color = "darkgreen">
<b>Go to Page: </b>
<%
FOR i = 1 to GOSSearchRS.PageCount
IF i <> cINT( pg ) THEN
%>
<a href="GregStoreMPSearchPage.asp?searchfor=<%=Server.URLEncode( searchfor )%>&pg=<%=i%>">
<%=i%></a>
<%ELSE%>
<b><%=i%></b>
<% End IF %>
<% Next %>
</font>
<% End IF %>
<% else %>
<table width="350" cellpadding=5 cellspacing=0 border=0>
<tr>
<td>
<font face="Arial" color="darkblue">
<b>No Product Matched your search Terms </b>
</font>
</td>
</tr>
</table>
<% End IF %>
</td></tr>
</table>
<hr width=640>
Copyright © 2006 Dominguez-Burns Inc.
</center>
</body>
</HTML>
Greg
Coding makes the world go round!!!
|
|
|
|
|
why you want to put this condition
IF NOT GOSSearchRS.BOF AND GOSSearchRS.EOF THEN
This condition reads if recordset is not BOF and recordset is EOF then
do the execution. If recordset is already EOF the from where u will get the new record.
try this
IF NOT GOSSearchRS.EOF THEN
cheers,
Akhilesh Yadav
|
|
|
|
|
Hello,
I've written an HTTPModule that process HttpContext.Response's data, I need to open an .xml file that's located into application's path (where there's web.config)... for now I've written "C:\\InetPub\\......" but I want to better the code....... how I obtain that???
Thanks
Bests
Paolo
|
|
|
|
|
use virtual path.
on putting "../" you go to parent folder of the current directory
cheers,
Akhilesh Yadav
|
|
|
|
|
Hi!
What a want to do is to have a LinkButton, or Button on a page, and when I press the button I want to open a new Window (javascript I suppose  and print the result of the postback in the new window, i.e. anything generated from the LinkButton.Click should be written in the new window.
Thanks!
/ N
|
|
|
|
|
the result must to be a Session Var
On html Code ( page 1)
<br />
page.registerstartupscript("str",str)<br />
OnLinkButtonClick
<br />
dim str as string = "<script language=javascript>window.open('page2.aspx',target='_blank')</script>"<br />
OnLoad (Page 2)
<br />
label1.Text = --SessionVar--;<br />
keep Learning and you never will be out of date...
|
|
|
|
|
I am C# developer. I need to learn about SSIS looping.
I have to go through each database and each table
and create text file of each table.
Any help
Sanjeev
|
|
|
|
|
The index page on a website i'm designing contains a menu for, well, navigation. My question is what is the best route to dynamically set the menu's SiteMapProvider to the correct provider based on a users login credentials.
Nathan Lindley
|
|
|
|
|
Hi
I have built 2 .net user controls and placed them both on the same page. One control (headlinedisplay.ascx) displays headlines from a webservice and the other displays the full article of a headline when you click on a headline links in the first usercontrol(articleDisplay.ascx).
I am displaying the headlines from headlinedisplay by progamatically creating asp/html controls. The problem I have is that when I click on a headline(linkbutton) and the Articleclick event fires to render the article the headlines in the headlinedisplay user control dissapear becuase of the post back. I think this happens because the controls were created dynamically and I need to redraw them. (If I through the data into a datalist this doesnt happen but leads to other problems so i cant really use that as a solution)
Does anybody know of away around this?
thanks for your help,
|
|
|
|
|
There is no way around it. If you create controls dynamically, you have to create them every time the page is created.
---
b { font-weight: normal; }
|
|
|
|
|
Guffa,
thanks for the reply. I kind of figured that. I guess I will store the response from the webservice in a session vaiable and then just redisplay the headlines on postback.
|
|
|
|
|
Hello,
I want to add nodes to Asp.Net 2.0 SiteMapPath in my runtime code.
I did as follows:
' Create site map path node collection
Dim siteMapPathNodeCollection As SiteMapNodeCollection
' Add node
siteMapPathNodeCollection.Add(New SiteMapNode(...))
My problem is I am ask to insert a 'provider' in SiteMapNode. I don't get it.
I have a data view with various rows and 2 columns 'Title' and 'Url'.
All I want is add these rows values to my site map path.
I was trying to loop through each row in my dataview but I am getting this problem with the provider.
Can someone sugest me how to do this?
Thanks,
Miguel
|
|
|
|
|
Take a look at this:
XmlAttributeCollection attrColl = myElement.Attributes;<br />
<br />
Console.WriteLine("Display all the attributes in the collection...");<br />
for (int i = 0; i < attrColl.Count; i++)<br />
{<br />
Console.Write("{0} = ", attrColl[i].Name);<br />
Console.Write("{0}", attrColl[i].Value);<br />
Console.WriteLine();<br />
}
It is in C#, but I am sure, you can translate it to VB
Sincerely,
Elina
Life is great!!!
Enjoy every moment of it! 
|
|
|
|
|
Hi
I am a web developer currently teaching myself ASP.NET 2.0 (in c#) with MySQL (rare combination, but still viable?). Getting ASP.NET & MySQL to work together at first was difficult, but now I understand the basics most code catered towards MS SQL can be altered to work with MySQL.
I mainly create bespoke content management systems for clients, so even though my knowledge is quite weak I am still putting it to regular use and constantly learning new things. I keep coming up against silly bugs/problems, or am having to write an awful lot of code (sometimes snippets twice) because I am not clued up on the best practices as I am essentially just making it up as I go along.
The tutorials and articles here are generally useful, but can sometimes be written crudely as they will only serve one purpose and no point in confusing someone by overcomplicating the methods. Alot of resources out there are catered towards 1.0 and 1.1 - when an awful lot changed in 2.0.
When I was learning PHP it was a great help to find opensource projects to delve into (even ones not classed as opensource still were of help because the code is always available). But with ASP.NET, practically everything is closed source (.dll's) and/or you have to pay a high price to see the source code.
Could anyone please recommend me any books worth getting, or offer any advice on how to find better online resources, or perhaps point me in the direction of some opensource projects I can look at - or towards some opensource groups I could collaborate with.
Thanks
|
|
|
|
|
|
Hello everyone,
Thanks in advance for any responses.
I had a question about developing a custom web service written in .net 2.0 for Windows SharePoint Services (i.e. running in _vti_bin or _Layouts directories). I can write a custom web service in .net 1.1, however, I am having an issue with the discovery of the wsdl for the 2.0 web service. I believe it has to do with the differences between 1.1 and 2.0 web project compilations. There is a great article for writing custom web services for sharepoint on msdn http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_sp2003_ta/html/odc_writingcustomwebservicesforsppt.asp
however, I need one in .net 2.0, any help would be greatly appreciated...
Brandon
braber
|
|
|
|
|
Hello,
I have an Asp.Net 2.0 Web.Sitemap file as follows:
...
<siteMap
xmlns = "http://schemas.microsoft.com/AspNet/SiteMap-File-1.0" >
<siteMapNode>
<siteMapNode
url = "~/default.aspx"
description = "Jaqueline Roxo Atelier"
title = "Página Inicial"
footer = "true" />
...
I want to loop through all 'siteMapNode' nodes and check if 'footer' attribute is true.
If 'footer' is true I want to add the 'url' and 'title' values to a data table or to a data view.
Is this possible?
Can someone suggest a way to do this?
Thanks,
Miguel
|
|
|
|
|
Yes, this is possible, look into the XmlDocument, XmlNode, XmlNodeList classes, then look for simple xpath queries... something like (//sitemapnode[@footer='true']/) of just query all sitemapnodes and then look for the attribute in the XmlNode...
Brandon
braber
|
|
|
|
|
Is it possible to intercept keystrokes in asp.net? i have someone who wants a specific button that wants to be the enter button to fire that event. I know in vb.net for windows applications that you can basically choose which button you want. If someone out there has something, it would be very useful.
|
|
|
|
|
Javascript events will be your best bet. OnKeyDown and the like.
|
|
|
|
|
How would i be able to fire a method in code behind if im using javascipt?
|
|
|
|
|
By making a postback.
---
b { font-weight: normal; }
|
|
|
|
|
Don't use the code behind for this. Otherwise you will have to do a post back on each key stroke and you user will hate you. Use Javascript. Then you can do a form.submit to fire the post back or some other mechinisum.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
