Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Using Visual Foxpro for a database on a web site?????
Message
De
01/01/2001 21:21:26
Peter Brama
West Pointe Enterprises
Detroit, Michigan, États-Unis
 
Information générale
Forum:
Internet
Catégorie:
Active Server Page
Divers
Thread ID:
00457797
Message ID:
00458356
Vues:
28
>Might be a stupid question, but do the data *files* in the "New" folder have read/write priviledges on them for the ISUR account on the website? We had a "cannot update cursor" issue once where we built the site using native VFP tables, and the ISP had only set read/write permissions on the data folder, not the individual files themselves.
>
>Setting the permission on the folder did not actually ripple thgrough to the files. They had to select all of the data files individually and set the permissions. Everything worked fine from there on out.


Well, I checked that or at least tried to.... this is a Windows NT server that I don't have full access to but
under that assumption that it is NT, permissions shouldn't play a factor like UNIX does.

I did have a problem with the rs.Find but I fixed that. It tried every setting for the CursorType and LockType
trying to get past this error message....


Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Visual FoxPro Driver]Cannot update the cursor.

/new/userdel.asp, line 20



Here is the current code....

dim DBmiym
dim DBpath
set DBmiym=server.createobject("adodb.connection")
DBpath="sourceDB=" & server.mappath("../new")
DBmiym.Open "DRIVER={Microsoft Visual FoxPro Driver}; SourceType=DBF; " & DBpath & "; Exclusive=No"

set userSet=server.createobject("ADODB.RecordSet")
userSet.Open "select * from user",DBmiym,1,3,adCmdText

for each p_del in request("p_del")
userset.find "userid='" & trim(p_del) & "'"
userset.delete <<<<<<<<<--------------------------- This is line 20
userset.update
next



Any suggestions?

Pete
Peter Brama
West Pointe Enterprises

VFP is getting easier but STILL alot to learn!!
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform