Newsgroup: it.comp.www.asp
Titolo: problema con conversione

ho convertito delle maschere access in html (asp) con la conversione
automatica, come prevedevo ho avuto dei problemi a far funzionare le pagine
create: il caricamento della pagina sembra fermarsi su questa istruzione:
tempRS.Open sql, conn, 3, 3
dove precedentemente avevo definito:
tempRS = Server.CreateObject("ADODB.Recordset")
sql = "SELECT DISTINCTROW [Filtro Utenti Attivi].[Nome] FROM [Filtro Utenti
Attivi] "
conn = Server.CreateObject("ADODB.Connection") etc...
l'errore che interrompe la mia pagina web (che si vede solo editando il
codice html) e' questo:
Microsoft OLE DB Provider for ODBC Drivers    errore "80040e10"
[Microsoft][Driver ODBC Microsoft Access 97] Parametri insufficienti.
Previsto 1.
/web/cgi-bin/Utenti_1alx.asp,   riga 99
lo so che e' impossibile individuare l'errore senza avere tutto il codice
davanti ma mi basterebbero anche solo piccoli suggerimenti del tipo: "non e'
per caso non hai impostato...?" oppure "ti sei ricordata di...?" etc :-)
btw, che significano i parametri 3, 3 finali?
grazie in anticipo
Alessandra

 Attivi] "
l'errore e' nell'istruzione DISTINCTROW che e' invece DISTINCT
che tipo di sql va usato nelle pagine asp?
grazie
Alessandra

...

Dovrebbe essere l'SQL standard (mi pare ANSI); il 3, 3 (tra parentesi, io
solitamente uso 3, 2) è il modo in cui apri il recordset:
dalla documentazione DevStudio:
recordset.Open Source, ActiveConnection, CursorType, LockType, Options
CursorType
 Optional. A CursorTypeEnum value that determines the type of cursor that
the provider should use when opening the Recordset. Can be one of the
following constants:
 adOpenForwardOnly, 0 (Default)
adOpenKeyset, 1
adOpenDynamic, 2
adOpenStatic, 3
LockType
 Optional. A LockTypeEnum value that determines what type of locking
(concurrency) the provider should use when opening the Recordset. Can be one
of the following constants:
 adLockReadOnly, 1
adLockPessimistic, 2
adLockOptimistic, 3
adLockBatchOptimistic, 4
Options
 Optional. A CommandTypeEnum value that indicates how the provider should
evaluate the Source argument if it represents something other than a Command
object. Can be one of the following constants:
 adCmdText, 1 — Evaluate Source as a textual definition of a command.
adCmdTable, 2 — Evaluate Source as a table name.
adCmdStoredProc, 4 — Evaluate Source as a stored procedure.
adCmdUnknown, 8 — The type of command in the Source argument is not known.
adOpenForwardOnly
 0
 Forward-only cursor. Identical to a static cursor except that you can only
scroll forward through records. This improves performance in situations when
you only need to make a single pass through a recordset. (Default.)
adOpenKeyset
 1
 Keyset cursor. Like a dynamic cursor, except that you can't see records
that other users add, although records that other users delete are
inaccessible from your recordset. Data changes by other users are still
visible.
adOpenDynamic
 2
 Dynamic cursor. Additions, changes, and deletions by other users are
visible, and all types of movement through the recordset are allowed, except
for bookmarks if the provider doesn't support them.
adOpenStatic
 3
 Static cursor. A static copy of a set of records that you can use to find
data or generate reports. Additions, changes, or deletions by other users
are not visible.
adLockReadOnly
 1
 Read-only — you cannot alter the data.
adLockPessimistic
 2
 Pessimistic locking, record by record — the provider does what is necessary
to ensure successful editing of the records, usually by locking records at
the data source immediately upon editing.
adLockOptimistic
 3
 Optimistic locking, record by record — the provider uses optimistic
locking, locking records only when you call the Update method.
adLockBatchOptimistic
 4
 Optimistic batch updates — required for batch update mode as opposed to
immediate update mode.
Più di quello che desideravi, credo... :-)
                o------------------o
                |  Alessandro   |
                o------------------o


^v^v^v^v^v^v^v^v^v^v^v^v^v^v^v^v^v^v^v^v^v^v^v^v^v
Moderatore di it.comp.www.asp
Gruppo di supporto: 
http://www.asp-it.com
^v^v^v^v^v^v^v^v^v^v^v^v^v^v^v^v^v^v^v^v^v^v^v^v^v
iPoint Network 
http://www.ipoint2000.net
 Servizi, siti ed altro!
Personalizza le tue notizie con 
http://www.ipoint2000.net/now