Below is code to display in a drop down menu some addresses. There is two things i need to do. One is to not show if there are no records but also there could be duplicate records, How do i stop duplicates occuring...
View RepliesI'm trying to deal with a few records in a db that are missing data in one or more fields, which breaks my page, causing a BOF or EOF error, since the recordset is empty.
I can check for an initial EOF, before any traversing of the records, but don't know how exactly to bypass execution of the record accessing from there.
I have a bit of code like this in a do while loop:
Response.Write "<TR><TD>Subject Name</TD>"
Response.Write "<TD>" & objRS("WRsubjectName") & "</TD></TR>"
It works fine, but sometimes the Subject Name field is empty, so instead of a blank space, I'd like to put something like "Empty Recordset" there.
Is there anyway to do this with my current code?
how do you check if a recordset is empty? i am trying to write a code that checks in the database if a field is empty and if it is, it should equal to "No." . here's what i have so far:
If rs("contact")="" then
rs("contact")="No"
Else
rs("contact")=rs("contact")
End If
I am getting this error:
ADODB.Recordset (0x800A0CB3)
Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.
i want to test if a recordset is empty then print a sentence Else display the records.
i tried if recordset.recordcount = 0 then ..... else and it aint working. i want to use it for a delete.asp page cuz when the table is empty it throws an error.
I'm calling a SQL stored procedure with the folowing code. It seems to work fine but I want to know if it doesn't return any rows and the oRsCatList. eof is not working.
lcDisplayCatList = "Y"
Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open Session("strConn")
Set oCmd = Server.CreateObject("ADODB.Command")
set oCmd.ActiveConnection = oConn
oCmd.CommandText = "spCategoryList"
oCmd.commandtype = AdCmdStoredProc
oCmd.Parameters.Append oCmd.CreateParameter("@CatID",
adInteger, adParamInput)
oCmd.Parameters("@CatID") = lnCatID
set oRsCatList = oCmd.Execute
if oRsCatList.EOF then
lcDisplayCatList = "N"
end if
I have a results page with two result boxes and am trying to add 'Show if recordset is empty' for obvious reasons (in Dreamweaver Mx). BUT i've highlighted text (eg, criteria error) for one and used the show if....
which works fine but when i try to add it to the second box (different recordset) it doesn't work, WHY?? Just trying to show a message in case no box is filled or no data retieved on the query of the record set.
Trying to return a Recordset to an ASP and the Recordset is empty.
The StorredProc works in the query analyzer and it even works from a
quick VB app that I wrote to test it.
The storedproc that I am using is fairly complex (creates some
temporary tables and populates them with 'Insert Into Select ...', but
the during testing the only Select statements that return visible rows
is the final one that returns the finished table with an 'Order By
....'.
I am trying to figure out if I am receiving multiple recordsets or if
I am out of environment space. Do the 'Insert Into Select ..'
statements return empty or null recordsets ?
The structure of my app allows for creating sections inside of a topic. The sections have an order in which they are displayed. To create a section in a topic that has no sections I need to query the database to get the top order of the sections so the new section created will be at the bottom (thus having the highest section order number).
If there is an null set returned then The new section has an order of 1.
I can insert sections if there are other sections associated with the same topic inside of the table, but cannot set an initial order number if there are no section associated to that topic. Please help. I have tried checking against EOF and BOF and null and and an empty string and feel like baching my head against a wall.
The code is as follows: ....
How do you check to see if the query you loaded into a recordset - retuned nothing? I keep getting this error:
error '80020009' Exception occurred...
I have certain fields in my DB that are empty.
(In asp)
Code:
groupName=rsGroup("Namn")
if groupName="" then
groupName="(Missing name)"
End If
How do I test if the current field/record in the recordset is empty?
I have created the following code to create the recordset rsToBeApprovedLocalItemID. Unfortunately, the for next loop works properly only on the first cycle. The response.write(arrToBeApprovedCatSub(0)&arrToBeApprovedCatSub(1)&"<br>")works for each loop but the SQL statement sqlToBeApprovedLocalItemID returns a populated recordset only on the first loop.
On subsequent loops it is empty even though the arrToBeApprovedCatSub(0) and arrToBeApprovedCatSub(1) are alive and well. What's going on? This is truly weird behaviour. I have not come across something this funky before. Code:
Can someone tell me what code I need to write in order to prevent an empty recordset returning the error below?
I think the error is something to do with the page count.
Error:
ADODB.Recordset error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/newspublisher/edit/viewOlder.asp, line 17
Line 17 = objdata.AbsolutePage = lngPageNo
Code:
I´m making a asp page which creates a xml-file. The values for the xml-file will be calculated in a stored procedure. This procedure returns 3 recordsets. In my query analyser the stored procedure returns the right values. The problem on my asp page is that the stored procedure is executed, but the recordset is empty.
This is the error message from my internet explorer:
ADODB.Recordset (0x800A0CC1) Item cannot be found in the collection corresponding to the requested name or ordinal.
This is the code i´m using: ....
i have a file *.num and when i enter the full URL to download it he give my
a 404 error !
but when i rename the *.NUM by *.TXT everything coming ok !?
so how i can tell to IIS6 to accept *.num files ?
I dont have CDONTS support. i am using the following script. with this, even yahoo doesn't consider the email to be HTML and displays all the HTML tags and treats it as TEXT. here is the code i use! Please dont consider it abuse as i dont know how to encloase the code in TAGS!
<%
mes = ""
IsSuccess = false
sTo = Trim(Request.Form("txtTo"))
sFrom = Trim(Request.Form("txtFrom"))
sSubject = Trim(Request.Form("txtSubject"))
sMailServer = "127.0.0.1"
sBody = Trim(Request.Form("txtBody"))
if Request("__action")="TestEMail" then
TestEMail()
end if
Sub TestEMail()
Set objMail = Server.CreateObject("CDO.Message")
Set objConf = Server.CreateObject("CDO.Configuration")
Set objFields = objConf.Fields
With objFields
.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2
.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = sMailServer
.Item("http://schemas.microsoft.com/cdo/configuration/smtpconnectiontimeout") = 10
.Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25
.Update
End With
With objMail
Set .Configuration = objConf
.From = sFrom
.To = sTo
.Subject = sSubject
.TextBody = sBody
End With
Err.Clear
on error resume next
objMail.Send
if len(Err.Description) = 0 then
mes = " Message sent to " + sTo
mes = mes + " EMAIL SENT SUCCESSFULLY!"
IsSuccess = true
else
mes = " " + Err.Description + " TESTS FAILED!"
end if
Set objFields = Nothing
Set objConf = Nothing
Set objMail = Nothing
End sub
Sub Alert(html)
if IsSuccess then
Response.Write "<div class='testRelults' id='testSuccessful'><span class='testResult'>Success:</span>" & html & "</div>"
else
Response.Write "<div class='testRelults' id='testFailed'><span class='testResult'>Fail:</span>" & html & "</div>"
end if
End Sub
%>
am using a join query below to get multiple results from different related tables to form one. e.g
SELECT DISTINCT dbo.e_Wallet.subscriptions, dbo.e_Wallet.username, dbo.e_Wallet.status, dbo.e_Wallet.suspension, dbo.ewalletx_yr_registratn.email, dbo.ewalletx_yr_registratn.Fiscal_Yr, dbo.ewalletx_yr_registratn.end_date, dbo.e_walletpurse.purse
FROM dbo.e_Wallet INNER JOIN dbo.ewalletx_yr_registratn ON dbo.e_Wallet.registrationID = dbo.ewalletx_yr_registratn.registrationID AND dbo.e_Wallet.email = dbo.ewalletx_yr_registratn.email LEFT OUTER JOIN dbo.e_walletpurse ON dbo.e_Wallet.email = dbo.e_walletpurse.email AND dbo.e_Wallet.registrationID = dbo.e_walletpurse.regID
WHERE username = 'variable'
however it dosent seem to work or show any results on my asp page. What is wrong here ?
Im working on an automated email sending script which work real fine. I have to send 2 different list of email ( contact1 and contact2) of an acces database file (.mdb).
The fact is that my script work well but for some reason it only send the second list of email (contact2).
The script process the list contact1 without any error but obviously it isnt sending mail to those email.
It seems to be an easy fix mistake but i cant figure out why the first contact list isnt sending. Must be a "If then" mistake or something with the loop i think.
Heres the code: ......
I have a formview which im using to ammed records in a DB via a gridview. When an item is selected on the gridview its details are shown in the formview. Ive wrote the update statement for the Insert button in the formviews edit mode.
If i edit a record in the formview this updates the DB, but not the gridview striaght away. I have to click on one of the select buttons on the gridview to update this. I have gridview.databind() on the click event of the insert button of the formview and on pageload, if its a callback. Code:
Last week, my shopping cart was still working well until I began getting the following errors 2days ago..
Error Type:
ADODB.Recordset (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
../order/saveorder.asp, line 157
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)
Page:
GET /main/saveorder.asp
Could you check my code below and let me know what possibly the error is?
I have created a forum, in which I have 3 tables:
1: Table_Forum
2: Threads
3: Replies
I have it at the moment that on the main default.asp there is a recordset that will
display all records within that table, these are a list of forums that will be available.
I have a table that will show the forum name, and the description. This table is then looped using Do while not, now what i need to do is show how many records in the Treads table are related to each forum using asp. Code:
When there are no records for the certain row in my table I recieve this error:
ADODB.Field error '80020009'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/admin/Fixture.asp, line 0
I am working with an array that I am populating off my database. However, in some instances the array will be empty. Is there any way to determine an empty array besides ubound = 0 (which might mean 1 record in included)?
View Replies View Relatedusers are entering data, but when they submit the form, once in a while
request.forms returns an empty string instead of the string its
supposed to get. Anyone seen this behavior before? Is there a
solution
i want to count all the records in my database where a certain field is empty.
heres my statement:
"SELECT Count(*) As Total FROM table WHERE field1='value' AND field2=' ' "
gives an error.
If it not possible. can the next be done:
1 count all the records.
2 count the records where field2='Yes'
3 subtract the two to get where field 2 is empty?
i know it's just something small, but i can't seem to figure it out. i also tried field2 != 'Yes'
i'm trying to determine if a record is empty and when it's not, it has to show that record
to test, I put three X's in the code:
the content of rs("opmerking") isn't shown but the three X's are there:
Does someone know why ? Here is my code:
How the heck do you work out what is actually in a db field that appears to be empty? I have fields that appear to be empty but do not seem to evaluate to empty or null, so test using IsEmpty or IsNull are useless, I 'm guessing it contains spaces or non-printing characters of some sort but how do I test for these?
View Replies View RelatedHow can I know whether a folder is empty using FileSystemObject?
View Replies View RelatedThis one's probably been asked before but I'm tired of trying to find a
solution (if there is one!). I have an asp update page and I'd like to
convert all empty fields to NULL prior to updating the Access db rather than
permitting zero length fields in the db.
Is this possible? Is there any way
to globally declare this for all text fields on the asp page rather than
having to do a whole whack of "if then" formats? Is there something I can
set in the field's properties in Access that will deny zero length yet won't
cause the asp update to choke and return an error?
[.asp with VBSCRIPT and MS ACCESS]
I have a Recordset that pulls data if 'Promotion' field in data base contains 'promo' and subsequently displays data from a field called 'TourTitle' on my ASP page..
However if the 'Promotion' field is empty in the database, I get an error on my page.. I have tried to use the following, but it is not working..
Code: ...
I have a login page where I have three different ways to authenticate a
user.
1. Use integrated authentication and read the server variable AUTH_USER and
then verify if this is a valid user from a database. If OK I write some
session cookies and then re-direct to another page placed in the same folder
(which will read the cookie and verify that it is valid). This works OK.
2. Use anonymous login where the user is typing in a username/password which
is checked against a database and if OK I write session cookies and then
re-direct to other page which reads this cookie. This also work OK.
3. Now we read another server variable that is set by a third party oracle
product (don't know much about this product but when I print the value of
the servervariable it is OK). I write some cookies and then redirect to
another page. When I read the cookie now it is empty. If I read the cookie
just before I do my re-direct it is OK but after the re-direct it is empty.
Do you have any sugestion why the cookie becomes emtpy after the re-direct
in the third case but not in the other two? It is the same code doing the
actual reading/writing of the cookies in all three options above.
I'm trying to make a very simple condition about some variable if it is empty do something but my problem is that it always cannot see it is empty
i mean i have a field in a table called title and this field is some times empty
so i need to type "empty" if it is
i tried this code ....
I have a table in MS Access that's used for users to post announcements on. There's only one problem- if it's empty (meaning there are no announcements), the page returns an error stating that either BOF or EOF is true. Basically, it doesn't like the null status of the table. Is there a way to state something like 'There is nothing currently here.'? I've been playing with this code but it hasn't worked yet:
If an.EOF=an.BOF Then
Response.Write("There are currently no system announcements.")
Else
do while not an.eof
'This starts a loop that lists them all
End If