C.J. Cunningham
|
Posted: 01/08/2002, 2:33 PM |
|
I would like to update database records based on values in an ASCII text file that I upload to the server. Right now I do this using an update query created in MS Access on my desktop, then upload the updated database to the server. As the database grows this is getting more cumbersome.
Can I call an MS Access query from an ASP page?? Any help would be great. My evaluation version of CC is almost expired and this is my last major issue before I make my purchasing decision.
Thanks,
C.J. Cunningham
|
|
|
Alex Alexapolsky
|
Posted: 01/09/2002, 4:09 AM |
|
You can use MS Access queries in your CC application.
1) Query can be selected as a atable in Page editor
2) You can execute queries like this :
cn.execute (your_query_variable)
|
|
|
kenlyle
|
Posted: 01/10/2002, 8:40 AM |
|
I was mystified that Access 97 was returning what appeared to be empty tables in ASP. Seems Access/Codecharge/ASP will only populate a results grid based on a query if the fields are set as Label in CodeCharge.
|
|
|
??
|
Posted: 01/10/2002, 12:54 PM |
|
Eh? I'm getting full functionality from Access Query recordsets via CC.
Using just like native tables - full CodeCharge UID available.
|
|
|