mssql_query returns a boolean false instead an empty recordset when
am 09.11.2005 18:54:51 von unknown--------------ms030208060105000900090203
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Hi all,
Maybe I didn't explain myself quite wel, so I wil repeat the
queestion in other words.
I would like to know which is the correct answer I should obtain from
mssql_query. I have a server in which mssql_query is returning a false
boolean when it should return an empty recordset (as is doing in the
other server).
In other words, the question is why I have a server in which mssql_query
returns empty recordsets when the query doesn't match any record and I
have installed a new one in which instead of an empty recordset I get a
boolean valued to false.
Which one is ok and what can be the problem with the other.
I know I can test in each query if result is false or a resource but I
have more than a hundred queries and I would like to have the knew
server with the same behavour as the previous one, which it is also how
I think that it should work.
I'm sorry for the repetition of the topic, but I'm very interested in
having a better solution than putting if's in each query.
Thank you.
Pablo
--------------ms030208060105000900090203
Content-Type: application/x-pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"
Content-Description: S/MIME Cryptographic Signature
MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEH AQAAoIIWcjCC
BcAwggSooAMCAQICAQUwDQYJKoZIhvcNAQEFBQAwfzELMAkGA1UEBhMCRVUx JzAlBgNVBAoT
HkFDIENhbWVyZmlybWEgU0EgQ0lGIEE4Mjc0MzI4NzEjMCEGA1UECxMaaHR0 cDovL3d3dy5j
aGFtYmVyc2lnbi5vcmcxIjAgBgNVBAMTGUNoYW1iZXJzIG9mIENvbW1lcmNl IFJvb3QwHhcN
MDQwMjA5MTU0MjQ3WhcNMzQwMjA5MTU0MjQ3WjCB4DELMAkGA1UEBhMCRVMx LjAsBgkqhkiG
9w0BCQEWH2FjX2NhbWVyZmlybWFfY2NAY2FtZXJmaXJtYS5jb20xQzBBBgNV BAcTOk1hZHJp
ZCAoc2VlIGN1cnJlbnQgYWRkcmVzcyBhdCB3d3cuY2FtZXJmaXJtYS5jb20v YWRkcmVzcykx
EjAQBgNVBAUTCUE4Mjc0MzI4NzEZMBcGA1UEChMQQUMgQ2FtZXJmaXJtYSBT QTEtMCsGA1UE
AxMkQUMgQ2FtZXJmaXJtYSBDZXJ0aWZpY2Fkb3MgQ2FtZXJhbGVzMIIBIDAN BgkqhkiG9w0B
AQEFAAOCAQ0AMIIBCAKCAQEAo8Z7749NX9+pYBoYoUWFX9XwDxF7EySq2OGi 0HBFEoebM2RO
1U7RosjEzHNrgpp2l2n42ByvC4Jsuk/ccRhGeTkuMeq4Lbj8stdwD7bt192N pD1S7u2TMOR6
EAuuMAY+mHJ8U5wcJlVtOQ480V6ejsgSBChGgAfb79qhJX4f2Nt+BRulnf7r dbNEnEWQKPug
kjDUMWmPq8lyg9dblpM1lyWvVGTmrBu8+Lj6nBq+Px89vwkyw04KdMZDCWLs zs7aVLzgAq8Z
ZEtrrSlMFZQIpCZ26DcH/3p/eEWxzc5CnObdEgG8wn+e7nmsG88UnT2vkgAt uRTbq+uBSpH3
auTz4wIBA6OCAeUwggHhMBIGA1UdEwEB/wQIMAYBAf8CAQswPAYDVR0fBDUw MzAxoC+gLYYr
aHR0cDovL2NybC5jaGFtYmVyc2lnbi5vcmcvY2hhbWJlcnNyb290LmNybDAd BgNVHQ4EFgQU
th9OnRxokS43cmDhRo9apSoxMbkwgasGA1UdIwSBozCBoIAU45T1sU3p26Ep W1eLTXYGduHR
ooqhgYSkgYEwfzELMAkGA1UEBhMCRVUxJzAlBgNVBAoTHkFDIENhbWVyZmly bWEgU0EgQ0lG
IEE4Mjc0MzI4NzEjMCEGA1UECxMaaHR0cDovL3d3dy5jaGFtYmVyc2lnbi5v cmcxIjAgBgNV
BAMTGUNoYW1iZXJzIG9mIENvbW1lcmNlIFJvb3SCAQAwDgYDVR0PAQH/BAQD AgGGMCoGA1Ud
EQQjMCGBH2FjX2NhbWVyZmlybWFfY2NAY2FtZXJmaXJtYS5jb20wJwYDVR0S BCAwHoEcY2hh
bWJlcnNyb290QGNoYW1iZXJzaWduLm9yZzBbBgNVHSAEVDBSMFAGCysGAQQB gYcuCgkBMEEw
PwYIKwYBBQUHAgEWM2h0dHA6Ly9jcHMuY2FtZXJmaXJtYS5jb20vY3BzL2Fj X2NhbWVyZmly
bWFfY2MuaHRtbDANBgkqhkiG9w0BAQUFAAOCAQEAZfCqDwWC//xAaJ6kFktD foS38SJj9XkO
p2nPr0eUHxf9MPlQk5EoXysB2mulf1tXT5VcF0hArr1x5F+g2K7cRRhhQeqs bj9a5CKUbLE5
AJabzsd0RIhYyJIbIoynf4o76sY2zG7mFPhBQAiv40CEaI/ixBGfoWoqmwC2 QSKqv9uh06l9
IrQ6LAY+jPeGFnCKW0w3n0DVghrEp2XMNvpPms/8ADmU+sQMZZxIph6Qw5YE bJmi6x6Qzw6C
EWDoodIGyU55+JinsfVoK9LGflxZdN4/m73Fy9bYrkJ8G/XTEQ3vznVwAU9+ VuGcy26aLLeu
WVt08fqIv2y25ruqWygoLDCCCFMwggc7oAMCAQICAhMTMA0GCSqGSIb3DQEB BQUAMIHgMQsw
CQYDVQQGEwJFUzEuMCwGCSqGSIb3DQEJARYfYWNfY2FtZXJmaXJtYV9jY0Bj YW1lcmZpcm1h
LmNvbTFDMEEGA1UEBxM6TWFkcmlkIChzZWUgY3VycmVudCBhZGRyZXNzIGF0 IHd3dy5jYW1l
cmZpcm1hLmNvbS9hZGRyZXNzKTESMBAGA1UEBRMJQTgyNzQzMjg3MRkwFwYD VQQKExBBQyBD
YW1lcmZpcm1hIFNBMS0wKwYDVQQDEyRBQyBDYW1lcmZpcm1hIENlcnRpZmlj YWRvcyBDYW1l
cmFsZXMwHhcNMDUwMTI0MTIzOTE2WhcNMDYwMTI0MTIzOTE2WjCCAYwxCzAJ BgNVBAYTAkVT
MRwwGgYDVQQDFBNQYWJsbyBE7WF6IEFuemFsb25lMSgwJgYJKoZIhvcNAQkB FhlwYWJsby5h
bnphbG9uZUBpc28uYmJlLmVzMRIwEAYDVQQFEwk1MzUyNzUwN0sxFjAUBgNV BAQUDUTtYXog
QW56YWxvbmUxDjAMBgNVBCoTBVBhYmxvMU4wTAYKKwYBBAGBhy4eAhM+Q0lG IElWQSAoVkFU
IG51bWJlciBhcyBieSBhcnRpY2xlIDI4aCBvZiBEaXJlY3RpdmUgNzcvMzg4 L0VFQykxGzAZ
BgorBgEEAYGHLh4DEwtFU0EzMzY4NDMwOTEQMA4GA1UEChMHSVNPVFJPTjEU MBIGA1UECxQL
SW5mb3Jt4XRpY2ExEDAOBgNVBAwUB1TpY25pY28xUjBQBgNVBA0TSUNoYW1i ZXJzIG9mIENv
bW1lcmNlIFF1YWxpZmllZCBDZXJ0aWZpY2F0ZTogTmF0dXJhbCBQZXJzb24g Q0FNLVBGLVNX
LUtQU0MwgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBALd9QeM0lL+L2MH2 K7/uYeerPBg5
ROCBKZUe8Vz/ygDAprvrHNEaFTl87jqKoP2Iiq7wV3NWm7GtVLzx+kzOFKZl gX5eZ2JNf7/l
qV69KJTov2DR1SkWq9aHwq3kcdGi/Bpbk5fLeA33K5432N9AA8PCp6AAvxeO p+d/AOUo4WAd
AgMBAAGjggPqMIID5jAMBgNVHRMBAf8EAjAAMA4GA1UdDwEB/wQEAwIDuDAd BgNVHSUEFjAU
BggrBgEFBQcDAgYIKwYBBQUHAwQwEQYJYIZIAYb4QgEBBAQDAgWgMEIGCWCG SAGG+EIBAwQ1
FjNVUkk6aHR0cDovL3d3dy5jYW1lcmZpcm1hLmNvbS9hY19jYW1lcmZpcm1h X2NjLmNnaT8w
RgYJYIZIAYb4QgEIBDkWN1VSSTpodHRwOi8vY3BzLmNhbWVyZmlybWEuY29t L2Nwcy9hY19j
YW1lcmZpcm1hX2NjLmh0bWwwHQYDVR0OBBYEFBVdcGgqPVALfAKfL5T/v1vM d4kuMHgGCCsG
AQUFBwEBBGwwajBABggrBgEFBQcwAoY0aHR0cDovL3d3dy5jYW1lcmZpcm1h LmNvbS9jZXJ0
cy9hY19jYW1lcmZpcm1hX2NjLmNydDAmBggrBgEFBQcwAYYaaHR0cDovL29j c3AuY2FtZXJm
aXJtYS5jb20wgasGA1UdIwSBozCBoIAUth9OnRxokS43cmDhRo9apSoxMbmh gYSkgYEwfzEL
MAkGA1UEBhMCRVUxJzAlBgNVBAoTHkFDIENhbWVyZmlybWEgU0EgQ0lGIEE4 Mjc0MzI4NzEj
MCEGA1UECxMaaHR0cDovL3d3dy5jaGFtYmVyc2lnbi5vcmcxIjAgBgNVBAMT GUNoYW1iZXJz
IG9mIENvbW1lcmNlIFJvb3SCAQUwdgYDVR0fBG8wbTA0oDKgMIYuaHR0cDov L2NybC5jYW1l
cmZpcm1hLmNvbS9hY19jYW1lcmZpcm1hX2NjLmNybDA1oDOgMYYvaHR0cDov L2NybDEuY2Ft
ZXJmaXJtYS5jb20vYWNfY2FtZXJmaXJtYV9jYy5jcmwwJAYDVR0RBB0wG4EZ cGFibG8uYW56
YWxvbmVAaXNvLmJiZS5lczAqBgNVHRIEIzAhgR9hY19jYW1lcmZpcm1hX2Nj QGNhbWVyZmly
bWEuY29tMIGSBgNVHSAEgYowgYcwgYQGDSsGAQQBgYcuCgkCAQEwczA/Bggr BgEFBQcCARYz
aHR0cDovL2Nwcy5jYW1lcmZpcm1hLmNvbS9jcHMvYWNfY2FtZXJmaXJtYV9j Yy5odG1sMDAG
CCsGAQUFBwICMCQaIkNFUlRJRklDQURPIENVQUxJRklDQURPIC0gUkE6IEND MzMwMQYJYIZI
AYb4QgENBCQWIkNFUlRJRklDQURPIENVQUxJRklDQURPIC0gUkE6IENDMzMw LwYIKwYBBQUH
AQMEIzAhMAgGBgQAjkYBATAVBgYEAI5GAQIwCxMDRVVSAgEAAgEBMA0GCSqG SIb3DQEBBQUA
A4IBAQBoHJZuGzypVD/kpGbdnixMAR7qZLBOhj84ZrqLEEim7/PbR8QSHsFL AS8lgsjal4uD
wr5KwbLjMorMJukY9L/MacqR4be7xhhvKMBKFGMqSP6SZUac6hLfQ7dOn6Z+ 71SkuaFWA0uD
jfboP+Mbx1IsK421QB4A0A+Z2VmLZrC3XRYI6KAx8F7erEOoki2wtUsPlOFP EYHKKTPHq4Lm
HcDPulunDZbu22VOV/Gitc7aqT8bTvi+MRvu2cibtWUnCw5d+07Juzlz3+Qa q3Ki36xgcq5x
ZSYUm4AWmSU5wmaslRjxtPg8BqCIzG8HHRkT8LW/jKlv9BZUfKlNI460iZaF MIIIUzCCBzug
AwIBAgICExMwDQYJKoZIhvcNAQEFBQAwgeAxCzAJBgNVBAYTAkVTMS4wLAYJ KoZIhvcNAQkB
Fh9hY19jYW1lcmZpcm1hX2NjQGNhbWVyZmlybWEuY29tMUMwQQYDVQQHEzpN YWRyaWQgKHNl
ZSBjdXJyZW50IGFkZHJlc3MgYXQgd3d3LmNhbWVyZmlybWEuY29tL2FkZHJl c3MpMRIwEAYD
VQQFEwlBODI3NDMyODcxGTAXBgNVBAoTEEFDIENhbWVyZmlybWEgU0ExLTAr BgNVBAMTJEFD
IENhbWVyZmlybWEgQ2VydGlmaWNhZG9zIENhbWVyYWxlczAeFw0wNTAxMjQx MjM5MTZaFw0w
NjAxMjQxMjM5MTZaMIIBjDELMAkGA1UEBhMCRVMxHDAaBgNVBAMUE1BhYmxv IETtYXogQW56
YWxvbmUxKDAmBgkqhkiG9w0BCQEWGXBhYmxvLmFuemFsb25lQGlzby5iYmUu ZXMxEjAQBgNV
BAUTCTUzNTI3NTA3SzEWMBQGA1UEBBQNRO1heiBBbnphbG9uZTEOMAwGA1UE KhMFUGFibG8x
TjBMBgorBgEEAYGHLh4CEz5DSUYgSVZBIChWQVQgbnVtYmVyIGFzIGJ5IGFy dGljbGUgMjho
IG9mIERpcmVjdGl2ZSA3Ny8zODgvRUVDKTEbMBkGCisGAQQBgYcuHgMTC0VT QTMzNjg0MzA5
MRAwDgYDVQQKEwdJU09UUk9OMRQwEgYDVQQLFAtJbmZvcm3hdGljYTEQMA4G A1UEDBQHVOlj
bmljbzFSMFAGA1UEDRNJQ2hhbWJlcnMgb2YgQ29tbWVyY2UgUXVhbGlmaWVk IENlcnRpZmlj
YXRlOiBOYXR1cmFsIFBlcnNvbiBDQU0tUEYtU1ctS1BTQzCBnzANBgkqhkiG 9w0BAQEFAAOB
jQAwgYkCgYEAt31B4zSUv4vYwfYrv+5h56s8GDlE4IEplR7xXP/KAMCmu+sc 0RoVOXzuOoqg
/YiKrvBXc1absa1UvPH6TM4UpmWBfl5nYk1/v+WpXr0olOi/YNHVKRar1ofC reRx0aL8GluT
l8t4DfcrnjfY30ADw8KnoAC/F46n538A5SjhYB0CAwEAAaOCA+owggPmMAwG A1UdEwEB/wQC
MAAwDgYDVR0PAQH/BAQDAgO4MB0GA1UdJQQWMBQGCCsGAQUFBwMCBggrBgEF BQcDBDARBglg
hkgBhvhCAQEEBAMCBaAwQgYJYIZIAYb4QgEDBDUWM1VSSTpodHRwOi8vd3d3 LmNhbWVyZmly
bWEuY29tL2FjX2NhbWVyZmlybWFfY2MuY2dpPzBGBglghkgBhvhCAQgEORY3 VVJJOmh0dHA6
Ly9jcHMuY2FtZXJmaXJtYS5jb20vY3BzL2FjX2NhbWVyZmlybWFfY2MuaHRt bDAdBgNVHQ4E
FgQUFV1waCo9UAt8Ap8vlP+/W8x3iS4weAYIKwYBBQUHAQEEbDBqMEAGCCsG AQUFBzAChjRo
dHRwOi8vd3d3LmNhbWVyZmlybWEuY29tL2NlcnRzL2FjX2NhbWVyZmlybWFf Y2MuY3J0MCYG
CCsGAQUFBzABhhpodHRwOi8vb2NzcC5jYW1lcmZpcm1hLmNvbTCBqwYDVR0j BIGjMIGggBS2
H06dHGiRLjdyYOFGj1qlKjExuaGBhKSBgTB/MQswCQYDVQQGEwJFVTEnMCUG A1UEChMeQUMg
Q2FtZXJmaXJtYSBTQSBDSUYgQTgyNzQzMjg3MSMwIQYDVQQLExpodHRwOi8v d3d3LmNoYW1i
ZXJzaWduLm9yZzEiMCAGA1UEAxMZQ2hhbWJlcnMgb2YgQ29tbWVyY2UgUm9v dIIBBTB2BgNV
HR8EbzBtMDSgMqAwhi5odHRwOi8vY3JsLmNhbWVyZmlybWEuY29tL2FjX2Nh bWVyZmlybWFf
Y2MuY3JsMDWgM6Axhi9odHRwOi8vY3JsMS5jYW1lcmZpcm1hLmNvbS9hY19j YW1lcmZpcm1h
X2NjLmNybDAkBgNVHREEHTAbgRlwYWJsby5hbnphbG9uZUBpc28uYmJlLmVz MCoGA1UdEgQj
MCGBH2FjX2NhbWVyZmlybWFfY2NAY2FtZXJmaXJtYS5jb20wgZIGA1UdIASB ijCBhzCBhAYN
KwYBBAGBhy4KCQIBATBzMD8GCCsGAQUFBwIBFjNodHRwOi8vY3BzLmNhbWVy ZmlybWEuY29t
L2Nwcy9hY19jYW1lcmZpcm1hX2NjLmh0bWwwMAYIKwYBBQUHAgIwJBoiQ0VS VElGSUNBRE8g
Q1VBTElGSUNBRE8gLSBSQTogQ0MzMzAxBglghkgBhvhCAQ0EJBYiQ0VSVElG SUNBRE8gQ1VB
TElGSUNBRE8gLSBSQTogQ0MzMzAvBggrBgEFBQcBAwQjMCEwCAYGBACORgEB MBUGBgQAjkYB
AjALEwNFVVICAQACAQEwDQYJKoZIhvcNAQEFBQADggEBAGgclm4bPKlUP+Sk Zt2eLEwBHupk
sE6GPzhmuosQSKbv89tHxBIewUsBLyWCyNqXi4PCvkrBsuMyiswm6Rj0v8xp ypHht7vGGG8o
wEoUYypI/pJlRpzqEt9Dt06fpn7vVKS5oVYDS4ON9ug/4xvHUiwrjbVAHgDQ D5nZWYtmsLdd
FgjooDHwXt6sQ6iSLbC1Sw+U4U8RgcopM8erguYdwM+6W6cNlu7bZU5X8aK1 ztqpPxtO+L4x
G+7ZyJu1ZScLDl37Tsm7OXPf5BqrcqLfrGByrnFlJhSbgBaZJTnCZqyVGPG0 +DwGoIjMbwcd
GRPwtb+MqW/0FlR8qU0jjrSJloUxggQ7MIIENwIBATCB5zCB4DELMAkGA1UE BhMCRVMxLjAs
BgkqhkiG9w0BCQEWH2FjX2NhbWVyZmlybWFfY2NAY2FtZXJmaXJtYS5jb20x QzBBBgNVBAcT
Ok1hZHJpZCAoc2VlIGN1cnJlbnQgYWRkcmVzcyBhdCB3d3cuY2FtZXJmaXJt YS5jb20vYWRk
cmVzcykxEjAQBgNVBAUTCUE4Mjc0MzI4NzEZMBcGA1UEChMQQUMgQ2FtZXJm aXJtYSBTQTEt
MCsGA1UEAxMkQUMgQ2FtZXJmaXJtYSBDZXJ0aWZpY2Fkb3MgQ2FtZXJhbGVz AgITEzAJBgUr
DgMCGgUAoIICqTAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcBMBwGCSqGSIb3 DQEJBTEPFw0w
NTExMDkxNzU0NTFaMCMGCSqGSIb3DQEJBDEWBBQypiWv9VgGRsmQhsISwxey IguBiDBSBgkq
hkiG9w0BCQ8xRTBDMAoGCCqGSIb3DQMHMA4GCCqGSIb3DQMCAgIAgDANBggq hkiG9w0DAgIB
QDAHBgUrDgMCBzANBggqhkiG9w0DAgIBKDCB+AYJKwYBBAGCNxAEMYHqMIHn MIHgMQswCQYD
VQQGEwJFUzEuMCwGCSqGSIb3DQEJARYfYWNfY2FtZXJmaXJtYV9jY0BjYW1l cmZpcm1hLmNv
bTFDMEEGA1UEBxM6TWFkcmlkIChzZWUgY3VycmVudCBhZGRyZXNzIGF0IHd3 dy5jYW1lcmZp
cm1hLmNvbS9hZGRyZXNzKTESMBAGA1UEBRMJQTgyNzQzMjg3MRkwFwYDVQQK ExBBQyBDYW1l
cmZpcm1hIFNBMS0wKwYDVQQDEyRBQyBDYW1lcmZpcm1hIENlcnRpZmljYWRv cyBDYW1lcmFs
ZXMCAhMTMIH6BgsqhkiG9w0BCRACCzGB6qCB5zCB4DELMAkGA1UEBhMCRVMx LjAsBgkqhkiG
9w0BCQEWH2FjX2NhbWVyZmlybWFfY2NAY2FtZXJmaXJtYS5jb20xQzBBBgNV BAcTOk1hZHJp
ZCAoc2VlIGN1cnJlbnQgYWRkcmVzcyBhdCB3d3cuY2FtZXJmaXJtYS5jb20v YWRkcmVzcykx
EjAQBgNVBAUTCUE4Mjc0MzI4NzEZMBcGA1UEChMQQUMgQ2FtZXJmaXJtYSBT QTEtMCsGA1UE
AxMkQUMgQ2FtZXJmaXJtYSBDZXJ0aWZpY2Fkb3MgQ2FtZXJhbGVzAgITEzAN BgkqhkiG9w0B
AQEFAASBgAJtDql7Z53xVH2QW3Mhr4VzGaN1vLjp9aLawNnNMeuYIXKEDdVW 9gIvToWhIJag
qraSLm+73S2iz3Htytt0VKcI/5aAENKdH0pP7C8BrOD0sGT51vmjZTWir61V PpyV/f2X4Kp6
W29+Wv294WYlR2rVazqG1LIl4cHd/BYMRNxJAAAAAAAA
--------------ms030208060105000900090203--