[RESOLVED] SQL Syntax Error

Hi could someone please tell me what im doing wrong here?

Set Rs = con.Execute("EXEC fillcalendar @myinput= " & lblMonthInt & " @myyear = " & cboYear)

Thanks

Quote:

---

Set Rs = con.Execute("EXEC fillcalendar @myinput= " & lblMonthInt & " @myyear = " & cboYear)

---

Code:

---

Set Rs = con.Execute("EXEC fillcalendar @myinput= '" & lblMonthInt & "' @myyear = '" & cboYear & "';")

---

That should do it..

Hope this helps

Kai

hmm nah it didnt

but this did :D

VB Code:

Set Rs = con.Execute("EXEC fillcalendar @myinput=" & lblMonthInt & ", @myyear=" & cboYear)