database connection 1

[Guest_imported]

this error accurs:
compilererror in Microsoft Vbscript-Fehler '800a03ee'
')' awaited
/Abfrage-D.asp, line 24

line 24:
set rs=sharknetc.execute("SELECT T_Domain.Domain, T_Domain.[FP-User],
T_Domain.[FP-Passwort], T_Domain.von, T_Domain.bis, T_Email.email,
T_Email.User, T_Email.Passwort, T_Email.von, T_Email.bis,
T_Kunden.Firma, T_Kunden.Name, T_Kunden.Vorname, T_Kunden.Strasse,
T_Kunden.PLZ, T_Kunden.Ort, T_Kunden.Tel FROM T_Kunden INNER JOIN
(T_Domain INNER JOIN T_Email ON T_Domain.[Domain-ID] =
T_Email.[Domain-ID]) ON T_Kunden.[Kunden-ID] = T_Domain.[Kunden-id]
WHERE T_Domain.Domain="repa.ch"&quot

i translated this error from german and hope i got it right

 

[rpet]

Try this:

...WHERE T_DOMAIN.Domain = 'repa.ch'&quot or

...WHERE T_DOMAIN.Domain = " & Chr(34) & "repa.ch" & Chr(34))

The second one uses the ", but I guess it should be '.

Another tip: You may create a view that joins all your tables and refer to it in your asp-script instead of using such a complex query. It makes your code much more readable.
[sig][/sig]

 

[DonP]

If you are calling all the fields in your database, you could do: ..("Select *from Databasename etc.....) rather than listing each one. I won't help with the problem but might make the coding easier. I'm not an expert but have done this myself when needing to load all or most of the fields from a table. I don't know if this will work with execute though.

Don [sig][/sig]