ERR_4: "eseguiSQL" in /var/www/arketipo.com/classes/mssql.class.php
Mex: Sintassi query SQL sbagliata


SELECT CAST(PhotoId AS VARCHAR(50)) as idfoto, 'Download/Multimedia/MD/' + CAST(PhotoId AS VARCHAR(50)) + sFileExtensionMD AS imgGalleriaMediumProdotto FROM vProductPhotos WHERE vProductPhotos.nRank=0 AND (vProductPhotos.sDestinazioneFileMD <> '') AND (PATINDEX('%ARK_SLIDE%', vProductPhotos.sDestinazioneFileMD) > 0) AND (vProductPhotos.ProductId='') order by sFileName
Array ( [0] => Array ( [0] => 42000 [SQLSTATE] => 42000 [1] => 8169 [code] => 8169 [2] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Conversione non riuscita durante la conversione di una stringa di caratteri nel tipo di dati uniqueidentifier. [message] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Conversione non riuscita durante la conversione di una stringa di caratteri nel tipo di dati uniqueidentifier. ) )
 Array
(
    [0] => Array
        (
            [file] => /var/www/arketipo.com/classes/mssql.class.php
            [line] => 123
            [function] => printError
            [class] => MSSQL
            [object] => MSSQL Object
                (
                    [useSQLSRV] => 1
                    [DBuser] => arketipo
                    [DBpass] => Gs938sv?
                    [DBhost] => localhost
                    [DBname] => dbArketipoWeb
                    [DBstatus] => 1
                    [DBquery] => SELECT
		CAST(PhotoId AS VARCHAR(50)) as idfoto,
		'Download/Multimedia/MD/' + CAST(PhotoId AS VARCHAR(50)) + sFileExtensionMD AS imgGalleriaMediumProdotto
		FROM vProductPhotos
		WHERE
		vProductPhotos.nRank=0 AND
		(vProductPhotos.sDestinazioneFileMD <> '') AND (PATINDEX('%ARK_SLIDE%', vProductPhotos.sDestinazioneFileMD) > 0) AND (vProductPhotos.ProductId='')
		order by sFileName
                    [DBrisultato] => 
                    [DBrighe] => 1
                    [DBpnt] => Resource id #1
                )

            [type] => ->
            [args] => Array
                (
                    [0] => 4
                    [1] => eseguiSQL
                    [2] => 
		SELECT
		CAST(PhotoId AS VARCHAR(50)) as idfoto,
		'Download/Multimedia/MD/' + CAST(PhotoId AS VARCHAR(50)) + sFileExtensionMD AS imgGalleriaMediumProdotto
		FROM vProductPhotos
		WHERE
		vProductPhotos.nRank=0 AND
		(vProductPhotos.sDestinazioneFileMD <> '') AND (PATINDEX('%ARK_SLIDE%', vProductPhotos.sDestinazioneFileMD) > 0) AND (vProductPhotos.ProductId='')
		order by sFileName
                )

        )

    [1] => Array
        (
            [file] => /var/www/arketipo.com/classes/layout.class.php
            [line] => 191
            [function] => eseguiSQL
            [class] => MSSQL
            [object] => MSSQL Object
                (
                    [useSQLSRV] => 1
                    [DBuser] => arketipo
                    [DBpass] => Gs938sv?
                    [DBhost] => localhost
                    [DBname] => dbArketipoWeb
                    [DBstatus] => 1
                    [DBquery] => SELECT
		CAST(PhotoId AS VARCHAR(50)) as idfoto,
		'Download/Multimedia/MD/' + CAST(PhotoId AS VARCHAR(50)) + sFileExtensionMD AS imgGalleriaMediumProdotto
		FROM vProductPhotos
		WHERE
		vProductPhotos.nRank=0 AND
		(vProductPhotos.sDestinazioneFileMD <> '') AND (PATINDEX('%ARK_SLIDE%', vProductPhotos.sDestinazioneFileMD) > 0) AND (vProductPhotos.ProductId='')
		order by sFileName
                    [DBrisultato] => 
                    [DBrighe] => 1
                    [DBpnt] => Resource id #1
                )

            [type] => ->
            [args] => Array
                (
                    [0] => 
		SELECT
		CAST(PhotoId AS VARCHAR(50)) as idfoto,
		'Download/Multimedia/MD/' + CAST(PhotoId AS VARCHAR(50)) + sFileExtensionMD AS imgGalleriaMediumProdotto
		FROM vProductPhotos
		WHERE
		vProductPhotos.nRank=0 AND
		(vProductPhotos.sDestinazioneFileMD <> '') AND (PATINDEX('%ARK_SLIDE%', vProductPhotos.sDestinazioneFileMD) > 0) AND (vProductPhotos.ProductId='')
		order by sFileName
                )

        )

    [2] => Array
        (
            [file] => /var/www/arketipo.com/dettaglio_prodotto.php
            [line] => 47
            [function] => getGalleriaDettaglioMediumProdotto
            [class] => Layout
            [object] => Layout Object
                (
                    [LayoutDB] => MSSQL Object
                        (
                            [useSQLSRV] => 1
                            [DBuser] => arketipo
                            [DBpass] => Gs938sv?
                            [DBhost] => localhost
                            [DBname] => dbArketipoWeb
                            [DBstatus] => 1
                            [DBquery] => SELECT
		CAST(PhotoId AS VARCHAR(50)) as idfoto,
		'Download/Multimedia/MD/' + CAST(PhotoId AS VARCHAR(50)) + sFileExtensionMD AS imgGalleriaMediumProdotto
		FROM vProductPhotos
		WHERE
		vProductPhotos.nRank=0 AND
		(vProductPhotos.sDestinazioneFileMD <> '') AND (PATINDEX('%ARK_SLIDE%', vProductPhotos.sDestinazioneFileMD) > 0) AND (vProductPhotos.ProductId='')
		order by sFileName
                            [DBrisultato] => 
                            [DBrighe] => 1
                            [DBpnt] => Resource id #1
                        )

                    [linguaSito] => ENG
                    [numCategorie] => 1
                )

            [type] => ->
            [args] => Array
                (
                    [0] => 
                )

        )

)