SQL = "SELECT strUrl FROM company " & _
"WHERE intID = " & intURL & _
" and intPayPerClick > 0 " & _
" and bolPayPerClick "
set mySQL = Conn.Execute(SQL)
if not Mysql.eof then
returnPath = mySQL("strUrl")
else
returnPath = ""
end if
Trådstart#1
' ## ACTIVE COMPANY
SQL = "SELECT intID, strURL, intPayPerClick, bolPayPerClick, strPayPerClickEmail " _
& " FROM [company] WHERE intID = " & intURL & ";"
set mySQL = Conn.Execute(SQL)
[b]intPayPerClick = mySQL(2)[/b]
IF [b]CInt(intPayPerClick) > 0[/b] AND bolPayPerClick = TRUE THEN
returnPath = mySQL(1)
Problemet är det markerade mekket... och tips på hur det ska fungera egenligen...??
