sql2k sp3a
One of my servers doesnt retain very much job history. I have no history for
several jobs that run once or more per day. Is there a limit to the amount
of records the SysJobHistory table can hold? Any other ideas?
TIA, ChrisRYes, you can define the limit. EM, right-click Agent, Properties. On one of the tabs, you can set
this.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ChrisR" <noemail@.bla.com> wrote in message news:evndYNpdFHA.2736@.TK2MSFTNGP12.phx.gbl...
> sql2k sp3a
> One of my servers doesnt retain very much job history. I have no history for several jobs that run
> once or more per day. Is there a limit to the amount of records the SysJobHistory table can hold?
> Any other ideas?
> TIA, ChrisR
>|||Thanks Tibor.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23EjtESpdFHA.1288@.tk2msftngp13.phx.gbl...
> Yes, you can define the limit. EM, right-click Agent, Properties. On one
> of the tabs, you can set this.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "ChrisR" <noemail@.bla.com> wrote in message
> news:evndYNpdFHA.2736@.TK2MSFTNGP12.phx.gbl...
>> sql2k sp3a
>> One of my servers doesnt retain very much job history. I have no history
>> for several jobs that run once or more per day. Is there a limit to the
>> amount of records the SysJobHistory table can hold? Any other ideas?
>> TIA, ChrisR
>sql
Showing posts with label sp3a. Show all posts
Showing posts with label sp3a. Show all posts
Friday, March 30, 2012
Wednesday, March 21, 2012
No attachments in subscription mail messages
We have reportingservices installed on the sql box. It's a W2K SP4 server
with sql2000 SP3a.
We have deployed several reports. All reports we have deployed after
installing SP1 do not contain an attached report (PDF, TIFF, Excel, CSV) but
when the report is rendered in the body of the message or when we view it in
the viewer there are no problems at all.
Reports deployed before installing SP1 are functioning correctly.
The following message we find in the logfiles:
aspnet_wp!library!c48!03/08/2005-14:29:41:: i INFO: Call to RenderFirst(
'/GMA_Test' )
aspnet_wp!library!c48!03/08/2005-14:29:51:: i INFO: Initializing
EnableExecutionLogging to 'True' as specified in Server system properties.
aspnet_wp!webserver!c48!03/08/2005-14:29:51:: i INFO: Processed report.
Report='/GMA_Test', Stream=''
aspnet_wp!library!c48!03/08/2005-14:29:52:: i INFO: Call to RenderNext(
'/GMA_Test' )
aspnet_wp!chunks!c48!03/08/2005-14:29:52:: i INFO: ###
GetReportChunk('RenderingInfo_HTML4.0', 2), chunk was not found!
this=8b4f21e9-99c6-45e0-a642-91bf34101b25
aspnet_wp!cache!c48!03/08/2005-14:29:52:: i INFO: Session live: /GMA_Test
aspnet_wp!webserver!c48!03/08/2005-14:29:52:: i INFO: Processed report.
Report='/GMA_Test', Stream=''
aspnet_wp!webserver!c48!03/08/2005-14:29:52:: i INFO: Processed report.
Report='/GMA_Test', Stream='524d8435-4afe-4a86-a02e-1bc9b4cb7f9d'
We have absolutly no clue!
Please help!Odd. Try http://support.microsoft.com/default.aspx?scid=kb;[LN];872774
I've sent posts by MSFT stating that hotfix fixes more than Lotus Notes
attachment issues.
--
Adrian M.
MCP
"Stefan Cremers" <s.cremers@.fritom.com> wrote in message
news:e%23jZcUJJFHA.3500@.TK2MSFTNGP14.phx.gbl...
> We have reportingservices installed on the sql box. It's a W2K SP4 server
> with sql2000 SP3a.
> We have deployed several reports. All reports we have deployed after
> installing SP1 do not contain an attached report (PDF, TIFF, Excel, CSV)
> but when the report is rendered in the body of the message or when we view
> it in the viewer there are no problems at all.
> Reports deployed before installing SP1 are functioning correctly.
> The following message we find in the logfiles:
> aspnet_wp!library!c48!03/08/2005-14:29:41:: i INFO: Call to RenderFirst(
> '/GMA_Test' )
> aspnet_wp!library!c48!03/08/2005-14:29:51:: i INFO: Initializing
> EnableExecutionLogging to 'True' as specified in Server system
> properties.
> aspnet_wp!webserver!c48!03/08/2005-14:29:51:: i INFO: Processed report.
> Report='/GMA_Test', Stream=''
> aspnet_wp!library!c48!03/08/2005-14:29:52:: i INFO: Call to RenderNext(
> '/GMA_Test' )
> aspnet_wp!chunks!c48!03/08/2005-14:29:52:: i INFO: ###
> GetReportChunk('RenderingInfo_HTML4.0', 2), chunk was not found!
> this=8b4f21e9-99c6-45e0-a642-91bf34101b25
> aspnet_wp!cache!c48!03/08/2005-14:29:52:: i INFO: Session live: /GMA_Test
> aspnet_wp!webserver!c48!03/08/2005-14:29:52:: i INFO: Processed report.
> Report='/GMA_Test', Stream=''
> aspnet_wp!webserver!c48!03/08/2005-14:29:52:: i INFO: Processed report.
> Report='/GMA_Test', Stream='524d8435-4afe-4a86-a02e-1bc9b4cb7f9d'
>
> We have absolutly no clue!
> Please help!
>|||Adrian,
Thanks for your help.
I installed the hotfix but nithing chanced. Our problem still exists.
"Adrian M." <absolutelynospam@.nodomain_.com> wrote in message
news:uARmooKJFHA.1476@.TK2MSFTNGP09.phx.gbl...
> Odd. Try http://support.microsoft.com/default.aspx?scid=kb;[LN];872774
> I've sent posts by MSFT stating that hotfix fixes more than Lotus Notes
> attachment issues.
> --
> Adrian M.
> MCP
>|||I have seen this similar issue. In my case I can send a link but if I send
the report nothing gets sent. I gave up and decided to wait for SP2 (this
month) and see if that fixes the problem.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Stefan Cremers" <s.cremers@.fritom.com> wrote in message
news:OubUtTOJFHA.732@.TK2MSFTNGP12.phx.gbl...
> Adrian,
> Thanks for your help.
> I installed the hotfix but nithing chanced. Our problem still exists.
>
> "Adrian M." <absolutelynospam@.nodomain_.com> wrote in message
> news:uARmooKJFHA.1476@.TK2MSFTNGP09.phx.gbl...
> > Odd. Try http://support.microsoft.com/default.aspx?scid=kb;[LN];872774
> >
> > I've sent posts by MSFT stating that hotfix fixes more than Lotus Notes
> > attachment issues.
> >
> > --
> > Adrian M.
> > MCP
> >
>|||This is odd. In my web app I programmatically create subscriptions that
include the report as an attachment and it works fine.
--
Adrian M.
MCP
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uILWefOJFHA.3500@.TK2MSFTNGP14.phx.gbl...
>I have seen this similar issue. In my case I can send a link but if I send
> the report nothing gets sent. I gave up and decided to wait for SP2 (this
> month) and see if that fixes the problem.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Stefan Cremers" <s.cremers@.fritom.com> wrote in message
> news:OubUtTOJFHA.732@.TK2MSFTNGP12.phx.gbl...
>> Adrian,
>> Thanks for your help.
>> I installed the hotfix but nithing chanced. Our problem still exists.
>>
>> "Adrian M." <absolutelynospam@.nodomain_.com> wrote in message
>> news:uARmooKJFHA.1476@.TK2MSFTNGP09.phx.gbl...
>> > Odd. Try http://support.microsoft.com/default.aspx?scid=kb;[LN];872774
>> >
>> > I've sent posts by MSFT stating that hotfix fixes more than Lotus Notes
>> > attachment issues.
>> >
>> > --
>> > Adrian M.
>> > MCP
>> >
>|||One thing I was told (but it was more than I wanted to do) was that the most
reliable method is to have the subscription be put in a directory for pickup
by your mail service. Might be something you would want to try.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Adrian M." <absolutelynospam@.nodomain_.com> wrote in message
news:uAA4RzOJFHA.580@.TK2MSFTNGP15.phx.gbl...
> This is odd. In my web app I programmatically create subscriptions that
> include the report as an attachment and it works fine.
> --
> Adrian M.
> MCP
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uILWefOJFHA.3500@.TK2MSFTNGP14.phx.gbl...
> >I have seen this similar issue. In my case I can send a link but if I
send
> > the report nothing gets sent. I gave up and decided to wait for SP2
(this
> > month) and see if that fixes the problem.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Stefan Cremers" <s.cremers@.fritom.com> wrote in message
> > news:OubUtTOJFHA.732@.TK2MSFTNGP12.phx.gbl...
> >> Adrian,
> >>
> >> Thanks for your help.
> >>
> >> I installed the hotfix but nithing chanced. Our problem still exists.
> >>
> >>
> >>
> >> "Adrian M." <absolutelynospam@.nodomain_.com> wrote in message
> >> news:uARmooKJFHA.1476@.TK2MSFTNGP09.phx.gbl...
> >> > Odd. Try
http://support.microsoft.com/default.aspx?scid=kb;[LN];872774
> >> >
> >> > I've sent posts by MSFT stating that hotfix fixes more than Lotus
Notes
> >> > attachment issues.
> >> >
> >> > --
> >> > Adrian M.
> >> > MCP
> >> >
> >>
> >
> >
>|||Here are some other things to check:
- Make sure the firewall (if one is being used) is set up to allow the MIME
type of the exported report to go out (PDF, Excel, etc). On most firewalls
you have to set up specific firewall rules to allow this (at least we had
to)
- On the SMTP server, make sure the 'Limit message size to (KB)' checkbox on
the SMTP Virtual Server property sheet Messages tab, is unchecked or specify
a sufficiently large enough value in the textbox. The default is is 2048KB.
If the default is checked and a report is bigger than this, the email will
not go with the attachment.
--
Adrian M.
MCP
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:eEI2b4OJFHA.3916@.TK2MSFTNGP14.phx.gbl...
> One thing I was told (but it was more than I wanted to do) was that the
> most
> reliable method is to have the subscription be put in a directory for
> pickup
> by your mail service. Might be something you would want to try.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Adrian M." <absolutelynospam@.nodomain_.com> wrote in message
> news:uAA4RzOJFHA.580@.TK2MSFTNGP15.phx.gbl...
>> This is odd. In my web app I programmatically create subscriptions that
>> include the report as an attachment and it works fine.
>> --
>> Adrian M.
>> MCP
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:uILWefOJFHA.3500@.TK2MSFTNGP14.phx.gbl...
>> >I have seen this similar issue. In my case I can send a link but if I
> send
>> > the report nothing gets sent. I gave up and decided to wait for SP2
> (this
>> > month) and see if that fixes the problem.
>> >
>> >
>> > --
>> > Bruce Loehle-Conger
>> > MVP SQL Server Reporting Services
>> >
>> > "Stefan Cremers" <s.cremers@.fritom.com> wrote in message
>> > news:OubUtTOJFHA.732@.TK2MSFTNGP12.phx.gbl...
>> >> Adrian,
>> >>
>> >> Thanks for your help.
>> >>
>> >> I installed the hotfix but nithing chanced. Our problem still exists.
>> >>
>> >>
>> >>
>> >> "Adrian M." <absolutelynospam@.nodomain_.com> wrote in message
>> >> news:uARmooKJFHA.1476@.TK2MSFTNGP09.phx.gbl...
>> >> > Odd. Try
> http://support.microsoft.com/default.aspx?scid=kb;[LN];872774
>> >> >
>> >> > I've sent posts by MSFT stating that hotfix fixes more than Lotus
> Notes
>> >> > attachment issues.
>> >> >
>> >> > --
>> >> > Adrian M.
>> >> > MCP
>> >> >
>> >>
>> >
>> >
>>
>
with sql2000 SP3a.
We have deployed several reports. All reports we have deployed after
installing SP1 do not contain an attached report (PDF, TIFF, Excel, CSV) but
when the report is rendered in the body of the message or when we view it in
the viewer there are no problems at all.
Reports deployed before installing SP1 are functioning correctly.
The following message we find in the logfiles:
aspnet_wp!library!c48!03/08/2005-14:29:41:: i INFO: Call to RenderFirst(
'/GMA_Test' )
aspnet_wp!library!c48!03/08/2005-14:29:51:: i INFO: Initializing
EnableExecutionLogging to 'True' as specified in Server system properties.
aspnet_wp!webserver!c48!03/08/2005-14:29:51:: i INFO: Processed report.
Report='/GMA_Test', Stream=''
aspnet_wp!library!c48!03/08/2005-14:29:52:: i INFO: Call to RenderNext(
'/GMA_Test' )
aspnet_wp!chunks!c48!03/08/2005-14:29:52:: i INFO: ###
GetReportChunk('RenderingInfo_HTML4.0', 2), chunk was not found!
this=8b4f21e9-99c6-45e0-a642-91bf34101b25
aspnet_wp!cache!c48!03/08/2005-14:29:52:: i INFO: Session live: /GMA_Test
aspnet_wp!webserver!c48!03/08/2005-14:29:52:: i INFO: Processed report.
Report='/GMA_Test', Stream=''
aspnet_wp!webserver!c48!03/08/2005-14:29:52:: i INFO: Processed report.
Report='/GMA_Test', Stream='524d8435-4afe-4a86-a02e-1bc9b4cb7f9d'
We have absolutly no clue!
Please help!Odd. Try http://support.microsoft.com/default.aspx?scid=kb;[LN];872774
I've sent posts by MSFT stating that hotfix fixes more than Lotus Notes
attachment issues.
--
Adrian M.
MCP
"Stefan Cremers" <s.cremers@.fritom.com> wrote in message
news:e%23jZcUJJFHA.3500@.TK2MSFTNGP14.phx.gbl...
> We have reportingservices installed on the sql box. It's a W2K SP4 server
> with sql2000 SP3a.
> We have deployed several reports. All reports we have deployed after
> installing SP1 do not contain an attached report (PDF, TIFF, Excel, CSV)
> but when the report is rendered in the body of the message or when we view
> it in the viewer there are no problems at all.
> Reports deployed before installing SP1 are functioning correctly.
> The following message we find in the logfiles:
> aspnet_wp!library!c48!03/08/2005-14:29:41:: i INFO: Call to RenderFirst(
> '/GMA_Test' )
> aspnet_wp!library!c48!03/08/2005-14:29:51:: i INFO: Initializing
> EnableExecutionLogging to 'True' as specified in Server system
> properties.
> aspnet_wp!webserver!c48!03/08/2005-14:29:51:: i INFO: Processed report.
> Report='/GMA_Test', Stream=''
> aspnet_wp!library!c48!03/08/2005-14:29:52:: i INFO: Call to RenderNext(
> '/GMA_Test' )
> aspnet_wp!chunks!c48!03/08/2005-14:29:52:: i INFO: ###
> GetReportChunk('RenderingInfo_HTML4.0', 2), chunk was not found!
> this=8b4f21e9-99c6-45e0-a642-91bf34101b25
> aspnet_wp!cache!c48!03/08/2005-14:29:52:: i INFO: Session live: /GMA_Test
> aspnet_wp!webserver!c48!03/08/2005-14:29:52:: i INFO: Processed report.
> Report='/GMA_Test', Stream=''
> aspnet_wp!webserver!c48!03/08/2005-14:29:52:: i INFO: Processed report.
> Report='/GMA_Test', Stream='524d8435-4afe-4a86-a02e-1bc9b4cb7f9d'
>
> We have absolutly no clue!
> Please help!
>|||Adrian,
Thanks for your help.
I installed the hotfix but nithing chanced. Our problem still exists.
"Adrian M." <absolutelynospam@.nodomain_.com> wrote in message
news:uARmooKJFHA.1476@.TK2MSFTNGP09.phx.gbl...
> Odd. Try http://support.microsoft.com/default.aspx?scid=kb;[LN];872774
> I've sent posts by MSFT stating that hotfix fixes more than Lotus Notes
> attachment issues.
> --
> Adrian M.
> MCP
>|||I have seen this similar issue. In my case I can send a link but if I send
the report nothing gets sent. I gave up and decided to wait for SP2 (this
month) and see if that fixes the problem.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Stefan Cremers" <s.cremers@.fritom.com> wrote in message
news:OubUtTOJFHA.732@.TK2MSFTNGP12.phx.gbl...
> Adrian,
> Thanks for your help.
> I installed the hotfix but nithing chanced. Our problem still exists.
>
> "Adrian M." <absolutelynospam@.nodomain_.com> wrote in message
> news:uARmooKJFHA.1476@.TK2MSFTNGP09.phx.gbl...
> > Odd. Try http://support.microsoft.com/default.aspx?scid=kb;[LN];872774
> >
> > I've sent posts by MSFT stating that hotfix fixes more than Lotus Notes
> > attachment issues.
> >
> > --
> > Adrian M.
> > MCP
> >
>|||This is odd. In my web app I programmatically create subscriptions that
include the report as an attachment and it works fine.
--
Adrian M.
MCP
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uILWefOJFHA.3500@.TK2MSFTNGP14.phx.gbl...
>I have seen this similar issue. In my case I can send a link but if I send
> the report nothing gets sent. I gave up and decided to wait for SP2 (this
> month) and see if that fixes the problem.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Stefan Cremers" <s.cremers@.fritom.com> wrote in message
> news:OubUtTOJFHA.732@.TK2MSFTNGP12.phx.gbl...
>> Adrian,
>> Thanks for your help.
>> I installed the hotfix but nithing chanced. Our problem still exists.
>>
>> "Adrian M." <absolutelynospam@.nodomain_.com> wrote in message
>> news:uARmooKJFHA.1476@.TK2MSFTNGP09.phx.gbl...
>> > Odd. Try http://support.microsoft.com/default.aspx?scid=kb;[LN];872774
>> >
>> > I've sent posts by MSFT stating that hotfix fixes more than Lotus Notes
>> > attachment issues.
>> >
>> > --
>> > Adrian M.
>> > MCP
>> >
>|||One thing I was told (but it was more than I wanted to do) was that the most
reliable method is to have the subscription be put in a directory for pickup
by your mail service. Might be something you would want to try.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Adrian M." <absolutelynospam@.nodomain_.com> wrote in message
news:uAA4RzOJFHA.580@.TK2MSFTNGP15.phx.gbl...
> This is odd. In my web app I programmatically create subscriptions that
> include the report as an attachment and it works fine.
> --
> Adrian M.
> MCP
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uILWefOJFHA.3500@.TK2MSFTNGP14.phx.gbl...
> >I have seen this similar issue. In my case I can send a link but if I
send
> > the report nothing gets sent. I gave up and decided to wait for SP2
(this
> > month) and see if that fixes the problem.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Stefan Cremers" <s.cremers@.fritom.com> wrote in message
> > news:OubUtTOJFHA.732@.TK2MSFTNGP12.phx.gbl...
> >> Adrian,
> >>
> >> Thanks for your help.
> >>
> >> I installed the hotfix but nithing chanced. Our problem still exists.
> >>
> >>
> >>
> >> "Adrian M." <absolutelynospam@.nodomain_.com> wrote in message
> >> news:uARmooKJFHA.1476@.TK2MSFTNGP09.phx.gbl...
> >> > Odd. Try
http://support.microsoft.com/default.aspx?scid=kb;[LN];872774
> >> >
> >> > I've sent posts by MSFT stating that hotfix fixes more than Lotus
Notes
> >> > attachment issues.
> >> >
> >> > --
> >> > Adrian M.
> >> > MCP
> >> >
> >>
> >
> >
>|||Here are some other things to check:
- Make sure the firewall (if one is being used) is set up to allow the MIME
type of the exported report to go out (PDF, Excel, etc). On most firewalls
you have to set up specific firewall rules to allow this (at least we had
to)
- On the SMTP server, make sure the 'Limit message size to (KB)' checkbox on
the SMTP Virtual Server property sheet Messages tab, is unchecked or specify
a sufficiently large enough value in the textbox. The default is is 2048KB.
If the default is checked and a report is bigger than this, the email will
not go with the attachment.
--
Adrian M.
MCP
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:eEI2b4OJFHA.3916@.TK2MSFTNGP14.phx.gbl...
> One thing I was told (but it was more than I wanted to do) was that the
> most
> reliable method is to have the subscription be put in a directory for
> pickup
> by your mail service. Might be something you would want to try.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Adrian M." <absolutelynospam@.nodomain_.com> wrote in message
> news:uAA4RzOJFHA.580@.TK2MSFTNGP15.phx.gbl...
>> This is odd. In my web app I programmatically create subscriptions that
>> include the report as an attachment and it works fine.
>> --
>> Adrian M.
>> MCP
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:uILWefOJFHA.3500@.TK2MSFTNGP14.phx.gbl...
>> >I have seen this similar issue. In my case I can send a link but if I
> send
>> > the report nothing gets sent. I gave up and decided to wait for SP2
> (this
>> > month) and see if that fixes the problem.
>> >
>> >
>> > --
>> > Bruce Loehle-Conger
>> > MVP SQL Server Reporting Services
>> >
>> > "Stefan Cremers" <s.cremers@.fritom.com> wrote in message
>> > news:OubUtTOJFHA.732@.TK2MSFTNGP12.phx.gbl...
>> >> Adrian,
>> >>
>> >> Thanks for your help.
>> >>
>> >> I installed the hotfix but nithing chanced. Our problem still exists.
>> >>
>> >>
>> >>
>> >> "Adrian M." <absolutelynospam@.nodomain_.com> wrote in message
>> >> news:uARmooKJFHA.1476@.TK2MSFTNGP09.phx.gbl...
>> >> > Odd. Try
> http://support.microsoft.com/default.aspx?scid=kb;[LN];872774
>> >> >
>> >> > I've sent posts by MSFT stating that hotfix fixes more than Lotus
> Notes
>> >> > attachment issues.
>> >> >
>> >> > --
>> >> > Adrian M.
>> >> > MCP
>> >> >
>> >>
>> >
>> >
>>
>
Saturday, February 25, 2012
newbie: True and False 0 and 1?
Hi,
I have an MSDE 2000 SP3a running on Win2k3, problem I have is that I am
writing a little basic web app. One of the fields I have set to bit
which I assumed I would use for True or False (1 or 0) - Using
Dreamweaver it seems that when I check a field in order to set it to
"true" it seems to have a value of -1 in the table? Why is this? Can
anyone shed some light for me
cheers
Baronne
On 11 Mar 2005 07:56:29 -0800, Baronne wrote:
>I have an MSDE 2000 SP3a running on Win2k3, problem I have is that I am
>writing a little basic web app. One of the fields I have set to bit
>which I assumed I would use for True or False (1 or 0) - Using
>Dreamweaver it seems that when I check a field in order to set it to
>"true" it seems to have a value of -1 in the table? Why is this? Can
>anyone shed some light for me
Hi Baronne,
The BIT datatype is not boolean. It is numeric, with only the values 0
and 1 allowed. Some people use BIT to represent booleans, but you'll
have to convert true to 1 (or 0) and false to 0 (or 1), and back again,
when going to and from the database.
Since SQL Server has no boolean datatype, you can pick wahtever you
want. I usually use a CHAR(1) datatype, with a CHECK constraint to make
sure that only 'T' or 'F' are allowd (or 'Y' / 'N' - depending on the
specific case).
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)
I have an MSDE 2000 SP3a running on Win2k3, problem I have is that I am
writing a little basic web app. One of the fields I have set to bit
which I assumed I would use for True or False (1 or 0) - Using
Dreamweaver it seems that when I check a field in order to set it to
"true" it seems to have a value of -1 in the table? Why is this? Can
anyone shed some light for me
cheers
Baronne
On 11 Mar 2005 07:56:29 -0800, Baronne wrote:
>I have an MSDE 2000 SP3a running on Win2k3, problem I have is that I am
>writing a little basic web app. One of the fields I have set to bit
>which I assumed I would use for True or False (1 or 0) - Using
>Dreamweaver it seems that when I check a field in order to set it to
>"true" it seems to have a value of -1 in the table? Why is this? Can
>anyone shed some light for me
Hi Baronne,
The BIT datatype is not boolean. It is numeric, with only the values 0
and 1 allowed. Some people use BIT to represent booleans, but you'll
have to convert true to 1 (or 0) and false to 0 (or 1), and back again,
when going to and from the database.
Since SQL Server has no boolean datatype, you can pick wahtever you
want. I usually use a CHAR(1) datatype, with a CHECK constraint to make
sure that only 'T' or 'F' are allowd (or 'Y' / 'N' - depending on the
specific case).
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)
Subscribe to:
Posts (Atom)