05. april 2000 - 13:53
Der er
15 kommentarer og 1 løsning
Det virker ikke!!!!
Jeg får denne Meddellelse: Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC Microsoft Access Driver] '' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long. Kodelinjen; objConn.Execute "INSERT INTO Links(Name,URL,Description,Category) VALUES(""" & Replace(StripHTML(SiteName),"""","""""") & """,""" & SiteURL & """,""" & Replace(StripHTML(SiteDescription),"""","""""") & """," & CategoryID & ")" Hvad kan jeg gøre for at få det til at virke????
Annonceindlæg fra itavis
05. april 2000 - 14:03
#1
objConn.Execute "INSERT INTO Links(Name,URL,Description,Category) VALUES('" & Replace(StripHTML(SiteName),","") & "','" & SiteURL & "','" & Replace(StripHTML(SiteDescription),",") & "'," & CategoryID & ")" ----- Drop alle de der nestet " er.... Prøv at fyre den her af og fortæl hvad den kommer med: StrSQL = "INSERT INTO Links(Name,URL,Description,Category) VALUES('" & Replace(StripHTML(SiteName),","") & "','" & SiteURL & "','" & Replace(StripHTML(SiteDescription),",") & "'," & CategoryID & ")" Response.write strSQL objConn.Execute(strSQL)
05. april 2000 - 14:15
#2
Den skriver hele linjen og fejlen er Expected ')'
05. april 2000 - 14:17
#3
Prøv at copy&paste den ind her !
05. april 2000 - 14:21
#4
Samme fejl igen
05. april 2000 - 14:22
#5
NEJ - Tag det din browser skriver og copy&paste det her !!!!
05. april 2000 - 14:25
#6
Microsoft VBScript compilation error '800a03ee' Expected ')' /nse-nitric/addlink.asp, line 19 StrSQL = "INSERT INTO Links(Name,URL,Description,Category) VALUES('" & Replace(StripHTML(SiteName),","") & "','" & SiteURL & "','" & Replace(StripHTML(SiteDescription),",") & "'," & CategoryID & ")" ------------------------------------------------------------------------------------------------------------^
05. april 2000 - 14:26
#7
"INSERT INTO Links(Name,URL,Description,Category) VALUES('" & Replace(StripHTML(SiteName),",") & "','" & SiteURL & "','" & Replace(StripHTML(SiteDescription),",") & "'," & CategoryID & ")" Sorry - Min fejl.....
05. april 2000 - 14:30
#8
Nu kommer der denne: Microsoft VBScript compilation error '800a0400' Expected statement /nse-nitric/addlink.asp, line 19 "INSERT INTO Links(Name,URL,Description,Category) VALUES('" & Replace(StripHTML(SiteName),",") & "','" & SiteURL & "','" & Replace(StripHTML(SiteDescription),",") & "'," & CategoryID & ")" ^
05. april 2000 - 14:33
#9
Det er en af dine fuktioner som den kalder - har jeg ret ?!!?
05. april 2000 - 14:36
#10
Linje 19 er: "INSERT INTO Links(Name,URL,Description,Category) VALUES('" & Replace(StripHTML(SiteName),",") & "','" & SiteURL & "','" & Replace(StripHTML(SiteDescription),",") & "'," & CategoryID & ")" ^
05. april 2000 - 14:44
#11
Ja - Returnere den funktion noget eller er det en sub ?!?!?!?
05. april 2000 - 14:45
#12
Vil du ikke hellere have filen???
05. april 2000 - 16:14
#13
Jo så send den til mig på mb@flco.dk
Expected ')' betyder at du mangler et ")" tegn et eller andet sted i din kode.. Der skal jo være lige mange "(" tegn og ")" tegn.. Delwin
Jeg fandt selv ud af det...
Kurser inden for grundlæggende programmering