Could someone please explain what t

[sknyppy]

Could someone please explain what this error means to me?

Item cannot be found in the collection corresponding to the requested name or ordinal.



If Not IsEmpty(Request.QueryString("EventID&quot) then
qGetConstructionDetails = "SELECT * FROM tbl_construction_events WHERE EventID = "&Request.QueryString("EventID&quot
SET ConstructionDetails = adoDataConn.Execute(qGetConstructionDetails)
For X = 1 to 1
qCopyIncident = "INSERT INTO tbl_dynamic_events "&_
"(CategoryID,EventTypeID,RegionID,CityID,EventText,CreatedOn,Persistence,Expiration) "&_
"VALUES('"&ConstructionDetails("CategoryID&quot&"',"&_
"'"&ConstructionDetails("EventTypeID&quot&"',"&_
"'"&ConstructionDetails("RegionID&quot&"',"&_
"'"&ConstructionDetails("CityID&quot&"',"&_
"'"&ConstructionDetails("EventText&quot&"',"&_
"'"&ConstructionDetails("LogDateTime&quot&"',"&_
"'no',"&_
"'"&ConstructionDetails("TimeToExpire&quot&"'"&_
&quot"
adoDataConn.Execute(qCopyIncident)
Next
End If

Thanks, Dave

 

[onpnt]

You have tried requesting a field from the recordset that does not exist.
You cannot mandate productivity, you must provide the tools to let people become their best.
-Steve Jobs
admin@onpntwebdesigns.com

 

[onpnt]

may be a misspelling or case issue. or it may just not exist You cannot mandate productivity, you must provide the tools to let people become their best.
-Steve Jobs
admin@onpntwebdesigns.com

 

[JuanitaC]

It means that one of the columns you are referencing was not found in your recordset. One way to fix this is to write out the columns that you need in your SQL statement rather than using SELECT *.

So try something like this:

qGetConstructionDetails = "SELECT CategoryID, EventTypeID, RegionID, CityID, etc... FROM tbl_construction_events WHERE EventID = "&Request.QueryString("EventID&quot

 

[sknyppy]

I have everything spelled out and I'm positive they exist.

If Not IsEmpty(Request.QueryString("EventID&quot) then
qGetConstructionDetails = "SELECT CategoryID,EventTypeID,RegionID,CityID,EventText,CreatedOn,Persistence,Expiration FROM tbl_construction_events WHERE EventID = "&Request.QueryString("EventID&quot
SET ConstructionDetails = adoDataConn.Execute(qGetConstructionDetails)
For X = 1 to 1
qCopyIncident = "INSERT INTO tbl_dynamic_events "&_
"(CategoryID,EventTypeID,RegionID,CityID,EventText,CreatedOn,Persistence,Expiration) "&_
"VALUES('"&ConstructionDetails("CategoryID&quot&"',"&_
"'"&ConstructionDetails("EventTypeID&quot&"',"&_
"'"&ConstructionDetails("RegionID&quot&"',"&_
"'"&ConstructionDetails("CityID&quot&"',"&_
"'"&ConstructionDetails("EventText&quot&"',"&_
"'"&ConstructionDetails("LogDateTime&quot&"',"&_
"'no',"&_
"'"&ConstructionDetails("TimeToExpire&quot&"'"&_
&quot"
adoDataConn.Execute(qCopyIncident)
Next
End If

 

[JuanitaC]

But in your SQL statement you have the column "Expiration" and where you are calling the columns to build your insert statement, you are referencing "TimeToExpire", for instance. Make sure that you are referencing all the proper column names.

So I can see that the columns "TimeToExpire" and "LogDateTime" do not exist in your sql statement.

 

[onpnt]

this is the total error disc. right?

ADODB.Recordset (0x800A0CC1)
Item cannot be found in the collection corresponding to the requested name or ordinal.

these fields are case sensitive also.
This is the only reasoning behind this error. You cannot mandate productivity, you must provide the tools to let people become their best.
-Steve Jobs
admin@onpntwebdesigns.com