print header / footer on all pages?

Is there a way to print the header and footer on all pages? Also I have a
footer and the textboxes in it wont print, lines will but no text the
expressions are like this (below) any idea? they show up on screen as on the
footer but when printed are blank
textbox1
="Page "+str(Globals!PageNumber)+" of "+str(Globals!TotalPages)
textbox2
="Report ran on "+Globals!ExecutionTimenope, the only thing on the page right now since its a brand new report is
the header and footer and the header has a single image in it and the footer
has a line above the two text boxes of which they are 50% of the width each
and left and right aligned, no overlapping...
"William" <William@.discussions.microsoft.com> wrote in message
news:0665879C-B9F3-4F58-86FC-75E74BF1A84B@.microsoft.com...
>I dropped your expressions into text boxes on a report I am working on and
> they both displayed correctly. Are you possible overlaying your footer
> with
> another text box?
> "Smokey Grindle" wrote:
>> Is there a way to print the header and footer on all pages? Also I have a
>> footer and the textboxes in it wont print, lines will but no text the
>> expressions are like this (below) any idea? they show up on screen as on
>> the
>> footer but when printed are blank
>> textbox1
>> ="Page "+str(Globals!PageNumber)+" of "+str(Globals!TotalPages)
>> textbox2
>> ="Report ran on "+Globals!ExecutionTime
>>|||ah got it, margin sizes where off
"Smokey Grindle" <nospam@.dontspamme.com> wrote in message
news:uhjRh0oNHHA.324@.TK2MSFTNGP06.phx.gbl...
> nope, the only thing on the page right now since its a brand new report is
> the header and footer and the header has a single image in it and the
> footer has a line above the two text boxes of which they are 50% of the
> width each and left and right aligned, no overlapping...
> "William" <William@.discussions.microsoft.com> wrote in message
> news:0665879C-B9F3-4F58-86FC-75E74BF1A84B@.microsoft.com...
>>I dropped your expressions into text boxes on a report I am working on and
>> they both displayed correctly. Are you possible overlaying your footer
>> with
>> another text box?
>> "Smokey Grindle" wrote:
>> Is there a way to print the header and footer on all pages? Also I have
>> a
>> footer and the textboxes in it wont print, lines will but no text the
>> expressions are like this (below) any idea? they show up on screen as on
>> the
>> footer but when printed are blank
>> textbox1
>> ="Page "+str(Globals!PageNumber)+" of "+str(Globals!TotalPages)
>> textbox2
>> ="Report ran on "+Globals!ExecutionTime
>>
>|||On Jan 12, 3:30 pm, "Smokey Grindle" <nos...@.dontspamme.com> wrote:
> ah got it, margin sizes where off
> "Smokey Grindle" <nos...@.dontspamme.com> wrote in message
> news:uhjRh0oNHHA.324@.TK2MSFTNGP06.phx.gbl...
> > nope, the only thing on the page right now since its a brand new report is
> > the header and footer and the header has a single image in it and the
> > footer has a line above the two text boxes of which they are 50% of the
> > width each and left and right aligned, no overlapping...
> > "William" <Will...@.discussions.microsoft.com> wrote in message
> >news:0665879C-B9F3-4F58-86FC-75E74BF1A84B@.microsoft.com...
> >>I dropped your expressions into text boxes on a report I am working on and
> >> they both displayed correctly. Are you possible overlaying your footer
> >> with
> >> another text box?
> >> "Smokey Grindle" wrote:
> >> Is there a way to print the header and footer on all pages? Also I have
> >> a
> >> footer and the textboxes in it wont print, lines will but no text the
> >> expressions are like this (below) any idea? they show up on screen as on
> >> the
> >> footer but when printed are blank
> >> textbox1
> >> ="Page "+str(Globals!PageNumber)+" of "+str(Globals!TotalPages)
> >> textbox2
> >> ="Report ran on "+Globals!ExecutionTime
I am having the same problem - where the footer appears when viewing
the report, but not when printing. Could you please elaborate on how
you fixed this with margin sizes?

print directly

--____XFEKHDBDURGVYUDZTEEH____
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
I would like print directly from my vb.net application to default printer = in the client pc.
how can i do it.
thnkas many thanks
_______________________________
* Alberto Garc=EDa S=E1nchez
* Subdirector Inform=E1tica
* Autobar Spain, S.A.
* Email: agarcia@.autobar-spain.com
* Web: www.autobar-spain.com * Telef. +34 916787345 _______________________________
___________________________________________________________________________=
Este mensaje se dirige exclusivamente a su destinatario
y puede contener informaci=F3n privilegiada o confidencial. Si no es vd. = el destinatario
indicado, queda notificado de que la utilizaci=F3n, divulgaci=F3n y/o = copia sin
autorizaci=F3n est=E1 prohibida en virtud de la legislaci=F3n vigente. Si = ha
recibido este mensaje por error, le rogamos que nos lo comunique
inmediatamente por esta misma v=EDa y proceda a su destrucci=F3n.
This message is intended exclusively for its addressee and may contain
information that is CONFIDENTIAL and protected by professional privilege.
If you are not the intended recipient you are hereby notified that any
dissemination, copy or disclosure of this communication is strictly
prohibited by law. If this message has been received in error, please
immediately notify us via e-mail and delete it.
___________________________________________________________________________
--____XFEKHDBDURGVYUDZTEEH____
Content-Type: multipart/related; boundary="____JFEIJVQFKYROWYHWADYT____"
--____JFEIJVQFKYROWYHWADYT____
Content-Type: text/html; charset=windows-1252
Content-Transfer-Encoding: quoted-printable
&
I would like print directly from my vb.net application to default = printer in the client pc.

how can i do it.

thnkas many thanks

_______________________________

* Alberto Garc=EDa S=E1nchez* Subdirector Inform=E1tica* = Autobar Spain, S.A.* Email: agarcia@.autobar-spain.com* Web: www.autobar-spain.com * Telef. +34 916787345 = _______________________________

__________________________________________________________________= _________Este mensaje se dirige exclusivamente a su destinatarioy = puede contener informaci=F3n privilegiada o confidencial. Si no es vd. el = destinatarioindicado, queda notificado de que la utilizaci=F3n, = divulgaci=F3n y/o copia sinautorizaci=F3n est=E1 prohibida en virtud = de la legislaci=F3n vigente. Si harecibido este mensaje por error, le = rogamos que nos lo comuniqueinmediatamente por esta misma v=EDa y = proceda a su destrucci=F3n. This message is intended = exclusively for its addressee and may containinformation that is = CONFIDENTIAL and protected by professional privilege.If you are not = the intended recipient you are hereby notified that anydissemination, = copy or disclosure of this communication is strictlyprohibited by law. = If this message has been received in error, pleaseimmediately notify = us via e-mail and delete it.___________________________________________= ________________________________
--____JFEIJVQFKYROWYHWADYT____--
--____XFEKHDBDURGVYUDZTEEH____--This is a multi-part message in MIME format.
--=_NextPart_000_0985_01C5420A.07D28330
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
There is a printer extension example delivered within the samples of the =Reporting Service SDK, perhaps yo may have a look in here.
HTH, Jens S=FC=DFmeyer
--
http://www.sqlserver2005.de
--
<alf> schrieb im Newsbeitrag =news:ulGhNifQFHA.3888@.TK2MSFTNGP10.phx.gbl...
I would like print directly from my vb.net application to default =printer in the client pc.
how can i do it.
thnkas many thanks
_______________________________
* Alberto Garc=EDa S=E1nchez
* Subdirector Inform=E1tica
* Autobar Spain, S.A.
* Email: agarcia@.autobar-spain.com
* Web: www.autobar-spain.com * Telef. +34 916787345 _______________________________
=_________________________________________________________________________=__
Este mensaje se dirige exclusivamente a su destinatario
y puede contener informaci=F3n privilegiada o confidencial. Si no es =vd. el destinatario
indicado, queda notificado de que la utilizaci=F3n, divulgaci=F3n y/o =copia sin
autorizaci=F3n est=E1 prohibida en virtud de la legislaci=F3n vigente. =Si ha
recibido este mensaje por error, le rogamos que nos lo comunique
inmediatamente por esta misma v=EDa y proceda a su destrucci=F3n.
This message is intended exclusively for its addressee and may contain
information that is CONFIDENTIAL and protected by professional =privilege.
If you are not the intended recipient you are hereby notified that any
dissemination, copy or disclosure of this communication is strictly
prohibited by law. If this message has been received in error, please
immediately notify us via e-mail and delete it.
=_________________________________________________________________________=__
--=_NextPart_000_0985_01C5420A.07D28330
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

There is a printer extension example delivered =within the samples of the Reporting Service SDK, perhaps yo may have a look in here.
HTH, Jens S=FC=DFmeyer
http://www.sqlserver2005.de
--
schrieb im Newsbeitrag news:ulGhNifQFHA.3888=@.TK2MSFTNGP10.phx.gbl...
I would like print directly from my vb.net application to default =printer in the client pc.

how can i do it.

thnkas many thanks

_______________________________

* Alberto Garc=EDa S=E1nchez* Subdirector Inform=E1tica* =Autobar Spain, S.A.* Email: agarcia@.autobar-spain.com* Web: http://www.autobar-spain.com">www.autobar-spain.com * Telef. +34 916787345 _______________________________

=________________________________________________________________=___________Este mensaje se dirige exclusivamente a su destinatarioy puede contener = informaci=F3n privilegiada o confidencial. Si no es vd. el destinatarioindicado, queda notificado de que la utilizaci=F3n, =divulgaci=F3n y/o copia sinautorizaci=F3n est=E1 prohibida en virtud de la =legislaci=F3n vigente. Si harecibido este mensaje por error, le rogamos que nos =lo comuniqueinmediatamente por esta misma v=EDa y proceda a su destrucci=F3n. This message is intended exclusively for =its addressee and may containinformation that is CONFIDENTIAL and =protected by professional privilege.If you are not the intended recipient you =are hereby notified that anydissemination, copy or disclosure of this communication is strictlyprohibited by law. If this message has =been received in error, pleaseimmediately notify us via e-mail and =delete =it.__________________________________________________________________=_________

---

--=_NextPart_000_0985_01C5420A.07D28330--|||This is a multi-part message in MIME format.
--=_NextPart_000_0121_01C541D4.7DE6D840
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
If you are using URL integration then the new client side printing with =the next service pack (hopefully imminent) might do the trick for you.
-- Bruce Loehle-Conger MVP SQL Server Reporting Services
<alf> wrote in message news:ulGhNifQFHA.3888@.TK2MSFTNGP10.phx.gbl...
I would like print directly from my vb.net application to default =printer in the client pc.
how can i do it.
thnkas many thanks
_______________________________
* Alberto Garc=EDa S=E1nchez
* Subdirector Inform=E1tica
* Autobar Spain, S.A.
* Email: agarcia@.autobar-spain.com
* Web: www.autobar-spain.com * Telef. +34 916787345 _______________________________
=_________________________________________________________________________=__
Este mensaje se dirige exclusivamente a su destinatario
y puede contener informaci=F3n privilegiada o confidencial. Si no es =vd. el destinatario
indicado, queda notificado de que la utilizaci=F3n, divulgaci=F3n y/o =copia sin
autorizaci=F3n est=E1 prohibida en virtud de la legislaci=F3n vigente. =Si ha
recibido este mensaje por error, le rogamos que nos lo comunique
inmediatamente por esta misma v=EDa y proceda a su destrucci=F3n.
This message is intended exclusively for its addressee and may contain
information that is CONFIDENTIAL and protected by professional =privilege.
If you are not the intended recipient you are hereby notified that any
dissemination, copy or disclosure of this communication is strictly
prohibited by law. If this message has been received in error, please
immediately notify us via e-mail and delete it.
=_________________________________________________________________________=__
--=_NextPart_000_0121_01C541D4.7DE6D840
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

If you are using URL integration then the new =client side printing with the next service pack (hopefully imminent) might do the =trick for you.
-- Bruce Loehle-Conger MVP SQL =Server Reporting Services
wrote in message news:ulGhNifQFHA.3888=@.TK2MSFTNGP10.phx.gbl...
I would like print directly from my vb.net application to default =printer in the client pc.

how can i do it.

thnkas many thanks

_______________________________

* Alberto Garc=EDa S=E1nchez* Subdirector Inform=E1tica* =Autobar Spain, S.A.* Email: agarcia@.autobar-spain.com* Web: http://www.autobar-spain.com">www.autobar-spain.com * Telef. +34 916787345 _______________________________

=________________________________________________________________=___________Este mensaje se dirige exclusivamente a su destinatarioy puede contener = informaci=F3n privilegiada o confidencial. Si no es vd. el destinatarioindicado, queda notificado de que la utilizaci=F3n, =divulgaci=F3n y/o copia sinautorizaci=F3n est=E1 prohibida en virtud de la =legislaci=F3n vigente. Si harecibido este mensaje por error, le rogamos que nos =lo comuniqueinmediatamente por esta misma v=EDa y proceda a su destrucci=F3n. This message is intended exclusively for =its addressee and may containinformation that is CONFIDENTIAL and =protected by professional privilege.If you are not the intended recipient you =are hereby notified that anydissemination, copy or disclosure of this communication is strictlyprohibited by law. If this message has =been received in error, pleaseimmediately notify us via e-mail and =delete =it.__________________________________________________________________=_________

---

--=_NextPart_000_0121_01C541D4.7DE6D840--|||This is a multi-part message in MIME format.
--=_NextPart_000_000D_01C541C4.983E43A0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
http://blogs.msdn.com/bryanke/articles/71491.aspx
<alf> wrote in message news:ulGhNifQFHA.3888@.TK2MSFTNGP10.phx.gbl...
I would like print directly from my vb.net application to default =printer in the client pc.
how can i do it.
thnkas many thanks
_______________________________
* Alberto Garc=EDa S=E1nchez
* Subdirector Inform=E1tica
* Autobar Spain, S.A.
* Email: agarcia@.autobar-spain.com
* Web: www.autobar-spain.com * Telef. +34 916787345 _______________________________
=_________________________________________________________________________=__
Este mensaje se dirige exclusivamente a su destinatario
y puede contener informaci=F3n privilegiada o confidencial. Si no es =vd. el destinatario
indicado, queda notificado de que la utilizaci=F3n, divulgaci=F3n y/o =copia sin
autorizaci=F3n est=E1 prohibida en virtud de la legislaci=F3n vigente. =Si ha
recibido este mensaje por error, le rogamos que nos lo comunique
inmediatamente por esta misma v=EDa y proceda a su destrucci=F3n.
This message is intended exclusively for its addressee and may contain
information that is CONFIDENTIAL and protected by professional =privilege.
If you are not the intended recipient you are hereby notified that any
dissemination, copy or disclosure of this communication is strictly
prohibited by law. If this message has been received in error, please
immediately notify us via e-mail and delete it.
=_________________________________________________________________________=__
--=_NextPart_000_000D_01C541C4.983E43A0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

http://blogs.msdn.com/bryanke/articles/71491.aspx">http://blogs.m=sdn.com/bryanke/articles/71491.aspx
wrote in message news:ulGhNifQFHA.3888=@.TK2MSFTNGP10.phx.gbl...
I would like print directly from my vb.net application to default =printer in the client pc.

how can i do it.

thnkas many thanks

_______________________________

* Alberto Garc=EDa S=E1nchez* Subdirector Inform=E1tica* =Autobar Spain, S.A.* Email: agarcia@.autobar-spain.com* Web: http://www.autobar-spain.com">www.autobar-spain.com * Telef. +34 916787345 _______________________________

=________________________________________________________________=___________Este mensaje se dirige exclusivamente a su destinatarioy puede contener = informaci=F3n privilegiada o confidencial. Si no es vd. el destinatarioindicado, queda notificado de que la utilizaci=F3n, =divulgaci=F3n y/o copia sinautorizaci=F3n est=E1 prohibida en virtud de la =legislaci=F3n vigente. Si harecibido este mensaje por error, le rogamos que nos =lo comuniqueinmediatamente por esta misma v=EDa y proceda a su destrucci=F3n. This message is intended exclusively for =its addressee and may containinformation that is CONFIDENTIAL and =protected by professional privilege.If you are not the intended recipient you =are hereby notified that anydissemination, copy or disclosure of this communication is strictlyprohibited by law. If this message has =been received in error, pleaseimmediately notify us via e-mail and =delete =it.__________________________________________________________________=_________

---

--=_NextPart_000_000D_01C541C4.983E43A0--

primary keys have gotten out of sequence

This is a multi-part message in MIME format.
--=_NextPart_000_0013_01C66A18.613BDBB0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
In Enterprise Manager, my primary keys used to be all in sequence. = After deleting a few pk and adding new ones, they are no longer in = sequence.
In Enterprise Manager, I would like to be able to view "Return all rows" = with the primary keys in numerical order.
What is the best way to accomplish this?
Thank you in advance,
TR
--=_NextPart_000_0013_01C66A18.613BDBB0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
In Enterprise Manager, my primary keys = used to be all in sequence. After deleting a few pk and adding new ones, they = are no longer in sequence.

In Enterprise Manager, I would like to = be able to view "Return all rows" with the primary keys in numerical = order.

What is the best way to accomplish this?

Thank you in advance,
TR
--=_NextPart_000_0013_01C66A18.613BDBB0--Timothy Ross wrote:
> In Enterprise Manager, my primary keys used to be all in sequence. After deleting a few pk and adding new ones, they are no longer in sequence.
> In Enterprise Manager, I would like to be able to view "Return all rows" with the primary keys in numerical order.
> What is the best way to accomplish this?
> Thank you in advance,
> TR
Tables have no inherent order. The only way to fix the order you see is
to use an ORDER BY clause in your SELECT statements. Enterprise Manager
won't do that for you - you need to write your own query. Preferably
use Query Analyzer instead because it's a much more powerful tool.
You'll need to familiarize yourself with SQL syntax first but that's
not so hard for the basic stuff. For example:
SELECT col1, col2, col3, ...
FROM your_table
ORDER BY col1 ;
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||David - Thank you for your quick response.
I understand that I can use query analyzer for sorting. I have actually
used Microsoft Access because this will allow sorting very easily.
I also understand that the primary keys really do not need to be displayed
in any particular order.
I have been told there is a command that will re-order my primary keys
sequentially so that I can view them in Enterprise Manager in the correct
order - it has something to do with INDEX on the column, but I haven't found
any information on how to accomplish his.
CREATE INDEX indexname tablename (column) -- doesn't reorder the primary key
the way that I want it to - I was wondering if there was a way to accomplish
this.
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:1146170512.392795.12240@.i40g2000cwc.googlegroups.com...
> Timothy Ross wrote:
>> In Enterprise Manager, my primary keys used to be all in sequence. After
>> deleting a few pk and adding new ones, they are no longer in sequence.
>> In Enterprise Manager, I would like to be able to view "Return all rows"
>> with the primary keys in numerical order.
>> What is the best way to accomplish this?
>> Thank you in advance,
>> TR
> Tables have no inherent order. The only way to fix the order you see is
> to use an ORDER BY clause in your SELECT statements. Enterprise Manager
> won't do that for you - you need to write your own query. Preferably
> use Query Analyzer instead because it's a much more powerful tool.
> You'll need to familiarize yourself with SQL syntax first but that's
> not so hard for the basic stuff. For example:
> SELECT col1, col2, col3, ...
> FROM your_table
> ORDER BY col1 ;
> --
> David Portas, SQL Server MVP
> Whenever possible please post enough code to reproduce your problem.
> Including CREATE TABLE and INSERT statements usually helps.
> State what version of SQL Server you are using and specify the content
> of any error messages.
> SQL Server Books Online:
> http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
> --
>|||In Enterprise Manager, I just went into "Table indexes and properties" --
verified that my primary key was under the "Column name" and the "Order" was
"Ascending". I then checked "Create as CLUSTERED"
My primary key column is now reordered numerically.
TR
"Timothy Ross" <ross_timothy@.hotmail.com> wrote in message
news:u6ZSyxjaGHA.508@.TK2MSFTNGP02.phx.gbl...
> David - Thank you for your quick response.
> I understand that I can use query analyzer for sorting. I have actually
> used Microsoft Access because this will allow sorting very easily.
> I also understand that the primary keys really do not need to be displayed
> in any particular order.
> I have been told there is a command that will re-order my primary keys
> sequentially so that I can view them in Enterprise Manager in the correct
> order - it has something to do with INDEX on the column, but I haven't
> found any information on how to accomplish his.
> CREATE INDEX indexname tablename (column) -- doesn't reorder the primary
> key the way that I want it to - I was wondering if there was a way to
> accomplish this.
>
> "David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
> news:1146170512.392795.12240@.i40g2000cwc.googlegroups.com...
>> Timothy Ross wrote:
>> In Enterprise Manager, my primary keys used to be all in sequence.
>> After deleting a few pk and adding new ones, they are no longer in
>> sequence.
>> In Enterprise Manager, I would like to be able to view "Return all rows"
>> with the primary keys in numerical order.
>> What is the best way to accomplish this?
>> Thank you in advance,
>> TR
>> Tables have no inherent order. The only way to fix the order you see is
>> to use an ORDER BY clause in your SELECT statements. Enterprise Manager
>> won't do that for you - you need to write your own query. Preferably
>> use Query Analyzer instead because it's a much more powerful tool.
>> You'll need to familiarize yourself with SQL syntax first but that's
>> not so hard for the basic stuff. For example:
>> SELECT col1, col2, col3, ...
>> FROM your_table
>> ORDER BY col1 ;
>> --
>> David Portas, SQL Server MVP
>> Whenever possible please post enough code to reproduce your problem.
>> Including CREATE TABLE and INSERT statements usually helps.
>> State what version of SQL Server you are using and specify the content
>> of any error messages.
>> SQL Server Books Online:
>> http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
>> --
>|||Timothy Ross wrote:
> In Enterprise Manager, I just went into "Table indexes and properties" --
> verified that my primary key was under the "Column name" and the "Order" was
> "Ascending". I then checked "Create as CLUSTERED"
> My primary key column is now reordered numerically.
>
You can create a clustered index but all that does is to fix the order
of data as it is stored. This doesn't guarantee that the data will
always be returned in the same order. Although in some cases it may
appear to give that effect you shouldn't rely on it.
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||David - I agree that if I delete some of my primary keys and add some new
ones that I would have to do this again to re-order them - it will not be
automatic.
TR
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:1146174590.856030.154560@.j73g2000cwa.googlegroups.com...
> Timothy Ross wrote:
>> In Enterprise Manager, I just went into "Table indexes and properties" --
>> verified that my primary key was under the "Column name" and the "Order"
>> was
>> "Ascending". I then checked "Create as CLUSTERED"
>> My primary key column is now reordered numerically.
> You can create a clustered index but all that does is to fix the order
> of data as it is stored. This doesn't guarantee that the data will
> always be returned in the same order. Although in some cases it may
> appear to give that effect you shouldn't rely on it.
> --
> David Portas, SQL Server MVP
> Whenever possible please post enough code to reproduce your problem.
> Including CREATE TABLE and INSERT statements usually helps.
> State what version of SQL Server you are using and specify the content
> of any error messages.
> SQL Server Books Online:
> http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
> --
>|||Timothy
This is NOT what David is saying.
There is absolutely no guarantee what order the rows from a table will be
returned, with a clustered index or without one. The only way to be sure
that you get the data in the order you want it is to request it to be sorted
with ORDER BY.
--
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Timothy Ross" <ross_timothy@.hotmail.com> wrote in message
news:eeUdtakaGHA.1192@.TK2MSFTNGP04.phx.gbl...
> David - I agree that if I delete some of my primary keys and add some new
> ones that I would have to do this again to re-order them - it will not be
> automatic.
> TR
> "David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
> news:1146174590.856030.154560@.j73g2000cwa.googlegroups.com...
>> Timothy Ross wrote:
>> In Enterprise Manager, I just went into "Table indexes and
>> properties" --
>> verified that my primary key was under the "Column name" and the "Order"
>> was
>> "Ascending". I then checked "Create as CLUSTERED"
>> My primary key column is now reordered numerically.
>>
>> You can create a clustered index but all that does is to fix the order
>> of data as it is stored. This doesn't guarantee that the data will
>> always be returned in the same order. Although in some cases it may
>> appear to give that effect you shouldn't rely on it.
>> --
>> David Portas, SQL Server MVP
>> Whenever possible please post enough code to reproduce your problem.
>> Including CREATE TABLE and INSERT statements usually helps.
>> State what version of SQL Server you are using and specify the content
>> of any error messages.
>> SQL Server Books Online:
>> http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
>> --
>|||Not sure what you are talking about - I did order the rows -- verified that
my primary key was under the "Column name" and the "Order" was
"Ascending"
This re-ordered my primary key column numerically.
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:e761cnkaGHA.3720@.TK2MSFTNGP03.phx.gbl...
> Timothy
> This is NOT what David is saying.
> There is absolutely no guarantee what order the rows from a table will be
> returned, with a clustered index or without one. The only way to be sure
> that you get the data in the order you want it is to request it to be
> sorted with ORDER BY.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.solidqualitylearning.com
>
> "Timothy Ross" <ross_timothy@.hotmail.com> wrote in message
> news:eeUdtakaGHA.1192@.TK2MSFTNGP04.phx.gbl...
>> David - I agree that if I delete some of my primary keys and add some new
>> ones that I would have to do this again to re-order them - it will not be
>> automatic.
>> TR
>> "David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
>> news:1146174590.856030.154560@.j73g2000cwa.googlegroups.com...
>> Timothy Ross wrote:
>> In Enterprise Manager, I just went into "Table indexes and
>> properties" --
>> verified that my primary key was under the "Column name" and the
>> "Order" was
>> "Ascending". I then checked "Create as CLUSTERED"
>> My primary key column is now reordered numerically.
>>
>> You can create a clustered index but all that does is to fix the order
>> of data as it is stored. This doesn't guarantee that the data will
>> always be returned in the same order. Although in some cases it may
>> appear to give that effect you shouldn't rely on it.
>> --
>> David Portas, SQL Server MVP
>> Whenever possible please post enough code to reproduce your problem.
>> Including CREATE TABLE and INSERT statements usually helps.
>> State what version of SQL Server you are using and specify the content
>> of any error messages.
>> SQL Server Books Online:
>> http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
>> --
>>
>|||I guess I misunderstood what you were talking about. I don't see how you can
have the primary key column NOT in order if you use ORDER BY when retrieving
the data.
But if you're satisfied, that's fine (for now).
--
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Timothy Ross" <ross_timothy@.hotmail.com> wrote in message
news:eozjgWtaGHA.3720@.TK2MSFTNGP03.phx.gbl...
> Not sure what you are talking about - I did order the rows -- verified
> that my primary key was under the "Column name" and the "Order" was
> "Ascending"
> This re-ordered my primary key column numerically.
>
> "Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
> news:e761cnkaGHA.3720@.TK2MSFTNGP03.phx.gbl...
>> Timothy
>> This is NOT what David is saying.
>> There is absolutely no guarantee what order the rows from a table will be
>> returned, with a clustered index or without one. The only way to be sure
>> that you get the data in the order you want it is to request it to be
>> sorted with ORDER BY.
>> --
>> HTH
>> Kalen Delaney, SQL Server MVP
>> www.solidqualitylearning.com
>>
>> "Timothy Ross" <ross_timothy@.hotmail.com> wrote in message
>> news:eeUdtakaGHA.1192@.TK2MSFTNGP04.phx.gbl...
>> David - I agree that if I delete some of my primary keys and add some
>> new ones that I would have to do this again to re-order them - it will
>> not be automatic.
>> TR
>> "David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
>> news:1146174590.856030.154560@.j73g2000cwa.googlegroups.com...
>> Timothy Ross wrote:
>> In Enterprise Manager, I just went into "Table indexes and
>> properties" --
>> verified that my primary key was under the "Column name" and the
>> "Order" was
>> "Ascending". I then checked "Create as CLUSTERED"
>> My primary key column is now reordered numerically.
>>
>> You can create a clustered index but all that does is to fix the order
>> of data as it is stored. This doesn't guarantee that the data will
>> always be returned in the same order. Although in some cases it may
>> appear to give that effect you shouldn't rely on it.
>> --
>> David Portas, SQL Server MVP
>> Whenever possible please post enough code to reproduce your problem.
>> Including CREATE TABLE and INSERT statements usually helps.
>> State what version of SQL Server you are using and specify the content
>> of any error messages.
>> SQL Server Books Online:
>> http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
>> --
>>
>>
>|||On Thu, 27 Apr 2006 16:52:04 -0400, "Timothy Ross"
<ross_timothy@.hotmail.com> wrote:
>I have been told there is a command that will re-order my primary keys
>sequentially so that I can view them in Enterprise Manager in the correct
>order - it has something to do with INDEX on the column, but I haven't found
>any information on how to accomplish his.
If you have a clustered index (or primary key) on the table, then the
physical and logical order will be the same.
But even then, a select statement without an order-by does not seem to
guarantee things will display in order. Just why not, I do not really
understand. May have to do with reuse of freed pages and order of
insertion, so the logical and physical *page* order are not the same,
irrespective of the logical and physical *row* orders.
Josh|||> But even then, a select statement without an order-by does not seem to
> guarantee things will display in order. Just why not, I do not really
> understand. May have to do with reuse of freed pages and order of
> insertion, so the logical and physical *page* order are not the same,
> irrespective of the logical and physical *row* orders.
SQL Server is free to return data in any sequence (e.g. most efficient
manner) unless the query contains ORDER BY. For example, there is a
'merry-go-round' scan feature that allows multiple concurrent queries to
'piggyback' on a scan already in progress. Once the later queries retrieve
the last row, the scan resumes at the beginning and continues until the
initially retrieved row is encountered. This could result in rows returned
in an arbitrary order.
It's good to have an understanding of the physical implementation for
performance analysis. However, you can rely only on the result described by
the SQL query.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"JXStern" <JXSternChangeX2R@.gte.net> wrote in message
news:gb88529oa6vkkdom9dgbtv9gfhhkh16u7e@.4ax.com...
> On Thu, 27 Apr 2006 16:52:04 -0400, "Timothy Ross"
> <ross_timothy@.hotmail.com> wrote:
>>I have been told there is a command that will re-order my primary keys
>>sequentially so that I can view them in Enterprise Manager in the correct
>>order - it has something to do with INDEX on the column, but I haven't
>>found
>>any information on how to accomplish his.
> If you have a clustered index (or primary key) on the table, then the
> physical and logical order will be the same.
> But even then, a select statement without an order-by does not seem to
> guarantee things will display in order. Just why not, I do not really
> understand. May have to do with reuse of freed pages and order of
> insertion, so the logical and physical *page* order are not the same,
> irrespective of the logical and physical *row* orders.
> Josh
>sql

Primary key question

Hi,

I am new to SQL 2000 and scratching my head...I am importing text files to SQL 2000 tables. How should I define the primary key in a table if the text file is :

Example 'customer invoice file'
column 1-Customer Bus Unit (Char 3)
column 2-Batch number (Char 6)
column 3-Document type (Char 1)
column 4-Invoice number (char 15)
column 5-Invoice dollar (Money)
column 6 - due date (date)
column 7 - customer name (char 35)
column 8 - customer address (char 50)

The primary key of this file is column1 + column 2 + coumn 3 + column 4. That concatnation of 4 fields make each record unique.
Should I define all 4 feilds as the primary key field? Thank you, Yanoroouh...yes...

Do you have a staging environemnt?

You can create work tables with no constraints...that way you can audit the data before it hit the final destination...|||Originally posted by Brett Kaiser
uh...yes...

Do you have a staging environemnt?

You can create work tables with no constraints...that way you can audit the data before it hit the final destination...

Please bear with me...
What do you mean a staging environment?
Could you suggest a work table design? (example)|||Sure...it's a table that looks like your final table...just that it has no keys, indexes or other constraints...even make all of the columns varchar (dates, money, ect)

You can the audit the data

LIKE

SELECT * FROM myTable99 WHERE ISDATE(adatecolumn) = 0

Will show you all rows with bad dates

SELECT * FROM myTable99 WHERE ISNUMERIC(anumericcolumn) = 0

Will show you all rows with non numbers in the expected number columns

PK violations

SELECT col1, col2, col3, col4, count(*)
FROM mytable99
GROUP BY col1, col2, col3, col4
HAVING COUNT(*) > 1

Shows where you'll have a dup key

ect

You can even make sure RI is ok...

If the data passes your audit, you can either bcp/dts or bulk insert the file, or Just INSERT it from your stage table...

Clear as mud?

Let me know...|||Okay, I will try that. Thank you very much.
I may encounter another questions... I will let you know.
Yanoroo|||Brett, are you still checking?
Not only the staging the work, I tried your PK violation check and it worked beautifully.
I appriciate your help. Yanoroo|||Hey....Merry Holiday

I'm glad it worked for you...It's always better to know that you're working with clean data...

TRUST NO ONE bearing Excel spreadsheets...(or other data sources outside your environment)..
Better still require data files with header and/or trailers...and if you can only get one...demand a trailer...with record counts and possible the sum of int/decimal columns...

Primary Key Constraint Violation

I need to insert a text file where might contains duplicate data into
a table with primary keys using a DTS package. is there anyone out
there could help me? I have tried couple way to get around, but still
doesn't work.I would load trhe text file in to a table of the correct structure, but =with no PK constraint. Then use SELECT DISTINCT -- to retrieve the =data you need and insert into final table. (INSERT INTO -- SELECT =DISTINCT -- FROM can by helpful for that part).
Mike John
"Matt" <tkiansoon@.yahoo.com> wrote in message =news:7a4ed84d.0308270840.25fe7496@.posting.google.com...
> I need to insert a text file where might contains duplicate data into
> a table with primary keys using a DTS package. is there anyone out
> there could help me? I have tried couple way to get around, but still
> doesn't work.|||You could load it into a staging table first and then de-dupe it or have a
index with ignore duplicate key on the staging table (but this would slow
the load unless the text file is ordered the same as the index which would
need to be unique clustered) and assumes that the entire row is a duplicate
if the key is.
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Matt" <tkiansoon@.yahoo.com> wrote in message
news:7a4ed84d.0308270840.25fe7496@.posting.google.com...
I need to insert a text file where might contains duplicate data into
a table with primary keys using a DTS package. is there anyone out
there could help me? I have tried couple way to get around, but still
doesn't work.

Primary Key

In a recent course on database programming using Microsoft Access 2002. I noticed that the text entitiled New Perspectives Microsoft Access 2002 stated that a primary key could only be used once per table. But If I am not mistaken could one use the select key to select more than one primary key within a table.If I am not taking ur sentance wrongly.
There is no limitation on select statement. But defining PK is for uniquess enforcement.|||In SQL Server or MS Access, only one Primary Key can be defined on a table, although this Primary Key may be a compound key consisting of more than one column.

A SELECT list can contain as many columns as you wish, regardless of whether they are primary keys.|||you can have only one primary key per table

that part is absolutely true

your comment "could one use the select key to select more than one primary key within a table" is slightly inaccurate, but you are on the right track

yes, you can, in the Design View for the table, select more than one column and make them the primary key

there can be only one primary key, but it may be a composite key, consisting of multiple colulmns|||Not the way the definition works... There should be one or more Candidate Keys (a column or columns that uniquely identify each row within the table). One of those Candidate Keys becomes the Primary Key just because the data modeler said so, by definition all of the rest of the Candidate Keys become Alternate Keys.

-PatP|||Huh? What are you reading? And what's most important, - what are you smoking? And can I have one?|||Originally posted by rdjabarov
what are you smoking? And can I have one? I don't smoke, so you'd better have two, they're small!

-PatP|||Pat and r937,

First of all thank you for your replies and I did do this selection in the design view while having the shift button selected.|||Ah-ha! I was thinking from a data modeler perspective. You were asking from an Access GUI user perspective. Fundamental communication error there!

Yes, Access allows you to select more than one column to become part of the primary key. The columns don't even have to be next to each other, you can use the first, third, fifth, and tenth columns if you like.

-PatP

primary filegroup is full?

Hi,
I'm trying to use DTS to import a text file into a table and I get an error
saying that space cannot be allocated for the file because the primary
filegroup is full.
Any ideas how to extend the primary filegroup?
thanksRafale
It looks like during the DTS's execution an autogrow feature kicks in and
it takes some time
Check it out if you have enough available space and try to import the data
with small tranasctions.
"Rafael Chemtob" <rchemtobb@.nospam.yahoo.com> wrote in message
news:%236fCfYeOFHA.244@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I'm trying to use DTS to import a text file into a table and I get an
error
> saying that space cannot be allocated for the file because the primary
> filegroup is full.
> Any ideas how to extend the primary filegroup?
> thanks
>|||Yes I hit the same deal a few years ago try to shrink the files and the
tran log in that does not work then you need more hard disk space. aka
another disk drive or nas
*** Sent via Developersdex http://www.examnotes.net ***|||Hi,
Looks like any one of the below 3 reasons had created this error:-
1. You have restricted the file growth
2. Transaction log (LDF) has gone high due to DTS
3. Not enough room in hard disk
The solutions for each of the above problems are:-
1. Remove the restricted growth and monitor the growth while DTS
2. Take Transaction log backup and shrink the LDF file. See Backup LOG and
DBCC SHRINKFILE commands in books online. After shrink start the
DTS
3. Add a new file (NDF) and put it in a hard disk drive where u have more
space and start DTS
Thanks
Hari
SQL Server MVP
"Rafael Chemtob" <rchemtobb@.nospam.yahoo.com> wrote in message
news:%236fCfYeOFHA.244@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I'm trying to use DTS to import a text file into a table and I get an
> error
> saying that space cannot be allocated for the file because the primary
> filegroup is full.
> Any ideas how to extend the primary filegroup?
> thanks
>

Previewing a report does not display the text fields at the correct position

Hi NG,
I've got a report in my report project in that the fields' position is
changed when previewing.
Have anybody recognized similar problems?On Apr 30, 6:16 am, "Martin Trabold" <m_trab...@.yahoo.de> wrote:
> Hi NG,
> I've got a report in my report project in that the fields' position is
> changed when previewing.
> Have anybody recognized similar problems?
Could you explain further. Do you mean fields changed order (i.e.,
Col1, Col2, Col4, Col3)? Or do you mean changed do to report borders
or page settings?
Enrique Martinez
Sr. Software Consultant

Preventing ALL text SQL Injection by removing single-quotes ?

I need to ask the user for some string (not INT) input... to
build a T-SQL "find" query in SQL Server 2000.
I do *NOT* need the user to ever search for "'"... so I'm removing the
single-quote character entirely.

> s = Replace(s, "'", "")
Can someone give a working example where SQL INJECTION would still be
possible?Hi Susan
You may want to read:
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=23
http://www.sommarskog.se/dynamic_sql.html#Security2
John
"Susan S via droptable.com" <forum@.droptable.com> wrote in message
news:50B826701CBE0@.droptable.com...
>I need to ask the user for some string (not INT) input... to
> build a T-SQL "find" query in SQL Server 2000.
> I do *NOT* need the user to ever search for "'"... so I'm removing the
> single-quote character entirely.
>
> Can someone give a working example where SQL INJECTION would still be
> possible?|||I can't find a single line of that article that *SHOWS* how a
string, fully stripped of all single-quotes... can be used for
Injection.
I'm not saying that it can't.
I just need someone to post the actual code.
Ever wonder why no one has the code?
Message posted via http://www.droptable.com|||Hi
You are assuming a certain business rule is applied which is probably
quite rare. You may be able to provide dropdowns if your values are so
specific and remove the need to type in anything!!
The parameterised query option is generic and can cater for all
sutuations, it should also be fast.
John|||John... that wasn't the question at all.
I *DO* have a need to search for text without containing any single-quotes.
(I couldn't possible have a dropdown box with 1000 different searches in it.
)
Why not simple say "I don't know" instead of answering a totally different
question?
John Bell wrote:
>Hi
>You are assuming a certain business rule is applied which is probably
>quite rare. You may be able to provide dropdowns if your values are so
>specific and remove the need to type in anything!!
>The parameterised query option is generic and can cater for all
>sutuations, it should also be fast.
>John
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...curity/200507/1|||"Susan S via droptable.com" <forum@.droptable.com> wrote in message
news:510817BAE9A30@.droptable.com...
> John... that wasn't the question at all.
> I *DO* have a need to search for text without containing any
> single-quotes.
> (I couldn't possible have a dropdown box with 1000 different searches in
> it.)
> Why not simple say "I don't know" instead of answering a totally different
> question?
You don't provide us with an example of your code that builds dynamic SQL so
we can only guess as to what might or might not work. Have you considered
char(39) being mixed in somehow?
But the larger question is, what is your aversion to parameterizing your
queries? If you were truly concerned about SQL injection, that's the route
you would go. Will you feel safe if nobody here can come up with an
example? Will that mean that it can't be done? You'd learn more hanging
out in hacker's circles, if that is your approach..
So, sorry if it offends you, and I'll admit that "I don't know" of a
specific example, but the real answer to your rhetorical question is:
parameterize, then you won't need to worry about it, there are no reasons it
can't be done, only excuses.
Good Luck,
Mark
[vbcol=seagreen]
> John Bell wrote:|||Well I started out the other day writing down a list from the sql server
perspective, but they all seem to start with the programmer making a
blunder. There are so many ways you can facilitate your site getting hacked
that it is really quite absurd. This is where a lot of the challenge exists.
If ever in the design of the system someone has said "It will never do such
and such" so you haven't coded defensively for the day you will have say
multiple sites on the one server (as an EG) then you have introduced time
bombs.
The most important thing about security is like so many things - expend your
effort where it will have most benefit.
I suggest you check your program code and ensure that no strings can
overflow buffers, that you use parameterised queries, that you check every
string not just for single quotes but also script and other HTML tags, for
code that can be evaluated to quotes, script, or html, that wherever
possible you remove as much need for free text entry as you can, do not
reflect errors verbatum back to the user - IE avoid replay attacks - do not
store data ever without sanitising it, do not show data with it being
santised (again), make everything as type safe as possible, normalise your
database properly, use maximum error and warning reporting when compiling,
use proper error handling, test the system thoroughly, try to break it, do
not accept warnings during compiles, and so on.
Add to that, use a DMZ, secure your web server, secure your database server,
enforce strong security... strong passwords,... I think you get the idea.
Now, look at your original question and ask yourself "was it responsible"?
Or do you think you can now check off the single quote character in
isolation? It is never a done task.
I suggest you re-read John's answer and references as a starter.
"Mark J. McGinty" <mmcginty@.spamfromyou.com> wrote in message
news:uX1WrSUhFHA.3256@.TK2MSFTNGP12.phx.gbl...
> "Susan S via droptable.com" <forum@.droptable.com> wrote in message
> news:510817BAE9A30@.droptable.com...
> You don't provide us with an example of your code that builds dynamic SQL
> so we can only guess as to what might or might not work. Have you
> considered char(39) being mixed in somehow?
> But the larger question is, what is your aversion to parameterizing your
> queries? If you were truly concerned about SQL injection, that's the
> route you would go. Will you feel safe if nobody here can come up with an
> example? Will that mean that it can't be done? You'd learn more hanging
> out in hacker's circles, if that is your approach..
> So, sorry if it offends you, and I'll admit that "I don't know" of a
> specific example, but the real answer to your rhetorical question is:
> parameterize, then you won't need to worry about it, there are no reasons
> it can't be done, only excuses.
>
> Good Luck,
> Mark
>
>
>
>|||Oh, of course, the biggest sin of them all - as Mark points out. Never use
dynamic SQL. You never need to for a correctly designed database.
"Mark J. McGinty" <mmcginty@.spamfromyou.com> wrote in message
news:uX1WrSUhFHA.3256@.TK2MSFTNGP12.phx.gbl...
> "Susan S via droptable.com" <forum@.droptable.com> wrote in message
> news:510817BAE9A30@.droptable.com...
> You don't provide us with an example of your code that builds dynamic SQL
> so we can only guess as to what might or might not work. Have you
> considered char(39) being mixed in somehow?
> But the larger question is, what is your aversion to parameterizing your
> queries? If you were truly concerned about SQL injection, that's the
> route you would go. Will you feel safe if nobody here can come up with an
> example? Will that mean that it can't be done? You'd learn more hanging
> out in hacker's circles, if that is your approach..
> So, sorry if it offends you, and I'll admit that "I don't know" of a
> specific example, but the real answer to your rhetorical question is:
> parameterize, then you won't need to worry about it, there are no reasons
> it can't be done, only excuses.
>
> Good Luck,
> Mark
>
>
>
>|||Wow.. it was just *ONE* simple request:
Post some *ACTUAL* code... that can cause SQL injection... where *ALL* singl
e
quote
characters have been removed from the string input by the user.
Seems like everyone is talking about eveything *OTHER* than that 1 simple
request.:

> Why not use another method instead?
> Why not fully secure your servers instead?
> Why not post your code?
> What are you using this for?
> You might needs users to enter single quotes some day.
> Why not write/use long parameterized methods instead?
> What if it's an INT, not a VarChar field?
> Why don't you go back and change 1000s of lines of code that you already w
rote?
> Let's talk about some totally different problems, instead of this one.
Sheezesss. That wasn't the question here. Here it is again:
s = GetUsersString() ' Get the input
s = Replace(s, "'", "") ' Remove all single-quotes
sql = "SELECT * FROM MyTable WHERE MyField='" & s & "'" ' Execute this
The Question:
In *ONE* line... without *ANY* explaination... what text would the user ente
r
as a value for "s",
that would break the above code sample?
So simple. No one can answer that? Or prove it can't be done?
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...curity/200507/1|||"Susan S via droptable.com" <forum@.droptable.com> wrote in message
news:5131626AFB930@.droptable.com...
> Wow.. it was just *ONE* simple request:
Considering all the good and relevant (despite your views) advice you've
received, it's obvious that you just don't get it; so go ahead and feel as
though you've written safe, secure code. Clearly, your mind is made up. I
think you've insulted the NG with your narrow-minded replies quite enough
for one thread.
What you refuse to accept is that it doesn't matter whether or not anyone in
this or any NG can provide you with an example. It simply doesn't matter.
It proves/disproves nothing. It does not mean it can't be done. You want
someone to prove for you that it *can* be done, otherwise you'll assume it
can't? That is a reckless approach at best.
So you choose to believe what you want to believe -- ok, fine. You chose to
ignore widely accepted best practices and now you want to justify that
choice -- that's all up to you. But don't expect the NG to validate those
choices, because -- and you know this as well as we do -- there is a body of
knowledge that says your chosen methodology is not the most secure, PERIOD,
bottom line, end of story.
And given today's Internet climate, why anyone would choose to do something
any way other than the most secure defies all reason. That's what we're on
about. That's why we can't get behind your over-simplification of the
issues.
And now I suppose you'll post another rude, frustrated, closed-minded reply
because I didn't stick to a one line answer... whatever... best of luck to
you too.
-Mark