|
|
Posted by alamb200 on 05/17/06 12:01
Hi
I am using a web page as my front end using ASP to pull the info from
the SQL database so I am in the position of either having multiple
columns with small bits of info in my database so I can format them how
I want
The other option is to have some commands built into the text in the
database entry which will be read by the system and control the
formatting when it is read.
Is this possible?
When I am trying to edit the info in the database all I am doing is
right clicking on the table in Enterprise manager and display all
columns and working on it from there.
Is this the right way to do this?
Anthony
Hugo Kornelis wrote:
> On 16 May 2006 04:13:58 -0700, alamb200@hotmail.com wrote:
>
> >I have just had a look at the parameter tag but as I am new to SQL I am
> >not sure how I would put this place.
> >
> >For example if my prefix charecter was / and my suffix charecter was \
> >for the sake of argument nad i wanted a new line after the full stop
> >in the following text how would I enter the information.
>
> Hi Anthony,
>
> wiith the right front-end, there's no need to use parameters. For
> instance, copy and paste the following into Query Analyzer and execute;
> you'll see that the output has exactly the lline breaks yoou asked for:
>
> CREATE TABLE test (KeyColumn int NOT NULL PRIMARY KEY,
> DataColumn varchar(1000) NOT NULL)
> INSERT INTO test (KeyColumn, DataColumn)
> VALUES (1, 'If your printer is no longer printing your logo''s or
> overlays it may have lost the images that have been "Flashed" on to it,
> to reflash your printer follow the following instructions.
> Log on to SB Client and go into the Company Files section.
> Next goto Runtime then Maintenance and System Manager Menu.')
> go
> SELECT * FROM test
> go
> DROP TABLE test
> go
>
> (Note: beware of extra line breaks inserted by Usenet software. In the
> intended code, there are line breaks after the periods, but no other
> line breaks in the VALUES clause.)
>
> >Also I seem to be unable to edit text already in the database and have
> >to delete it and reenter it every time, is there an easier way of doing
> >that.
>
> That, too, is a problem with your frontend.
>
> May I ask you what tool you are using as your frontend?
>
> --
> Hugo Kornelis, SQL Server MVP
Navigation:
[Reply to this message]
|