Forum Moderators: open

Message Too Old, No Replies

Type mismatch: 'makeSQLSafe'

         

surrealillusions

9:14 pm on Jun 25, 2009 (gmt 0)

10+ Year Member



Hi all,

Bit of background first, I have no idea at all about asp, however, i have basic knowledge in php if that helps at all.

Anyway, i have been handed this site written in asp to upload to our servers, and after numerous attempts with broken database files, and after 3 or 4 weeks of getting it uploaded, im greeted with server 500 errors. I've gone through and solved a couple of others (i think), but this one i have no clue on.

Despite numerous searches on Google, im still no closer to solving this problem.

Can anyone help?

Microsoft VBScript runtime error '800a000d'

Type mismatch: 'makeSQLSafe'

/page.asp, line 5

The lines are -


<!--#include file="inc/header.inc.asp" -->

<%
strActionTwo = request.querystring("action")
strAction = makeSQLSafe(strActionTwo)

marcel

5:16 am on Jun 26, 2009 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Hi surrealillusions, have you included the file containing the makeSQLSafe function?

The error you are getting means that the command you are trying to execute is not recognised. Either it is misspelt or the function does not exist.

surrealillusions

10:25 am on Jun 26, 2009 (gmt 0)

10+ Year Member



Could be a missing file.

As, in that header.inc file, it was calling in some func/functions, but that folder doesnt exist. I deleted that line as that was causing server 500 errors by the file been missing. Yet the site works on the old server (where I've downloaded the files via ftp from). And uploaded to the new one. I dont have direct access to either server, only ftp access to the old one, and a control panel for the new server.

marcel

10:11 am on Jun 29, 2009 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



I deleted that line as that was causing server 500 errors by the file been missing
That line may have been referencing a file that was in a virtual folder.

Have you tried searching through all of the files for a makeSQLSafe method?