Database record deletions are not being made

[rmz8]

I deleted records from a table within a database. However, when I run a template that calls this database, the old records still appear. I have uploaded the new database, created a new DSN, verified the DSN, deleted the database and reuploaded, and nothing--it still doesn't reflect the changes. However I know that uploading/deleting the database is doing something, because when I ran the template when the file was deleted, it ran into an error.

It is a Microsoft Access database, and I am using ColdFusion 4.5 Enterprise. [sig]<p>Ryan ;-]<br>[/sig]

 

[Guest_imported]

If you are running on a hosted server, or if you have caching enabled, this could be the cause of your trouble.

Try writting a fresh template, and in the query specify:

<cfquery
cachedwithin=CreateTimeSpan(0,0,0,0)
datasource=#DSN#
Name=QueryName
</cfquery>
.
.
.

 

[rmz8]

Thanks! But when I run the template the following error occurs:

Cannot convert CreateTimeSpan(0,0,0,0) to number. [sig]<p>Ryan ;-]<br>[/sig]

 

[rmz8]

I tried different variations of the TimeSpan function, with no success. What could it be? [sig]<p>Ryan ;-]<br>[/sig]

 

[Guest_imported]

I apologize, the post last night should have included the pound signs : )

<cfquery datasource=&quot;#DSN#&quot;
name=&quot;YourName&quot;
CachedWithin=#CreateTimeSpan(0,0,0,0)#>

One other thing.... the other cool trick to remove &quot;locks&quot; and caches is to build a
&quot;Known bad&quot; query. Something like where ID=Zebra .....

and if your original problem is not related to caching... we start scratching our heads lol