dman

RHCP - Don't forget me f'n awesome

Hey GSM! LTNS! I've been out of the code game so long I'll bet the student has beome the master... look forward to chatting w/ you.

Hi GSM, Long time no see. I've been off in other worlds, but thought I'd drop by and see if any of my old friends were around. You're gettin really good at this stuff, pal. Nice work. Hopefully I'll get some time to drop in more often. Be well, c ya round......

No one was interested when I mentioned this in best defrag thread. Maybe you will like it. It is called "dirms" (do it right MS). Very effective, free command line defragger. http://www.dirms.com/

Hi Martin, I have been so busy I don't have time to pee. Hope to dig into this over the weekend :-)

Cool. I know what you mean about project managers. I once had one that would not allow me to use SQL syntax with Visual Foxpro because XBase didn't have it, so I didn't need it. (read, "he didn't know it")

You are right, good skill to have. Everything is in a DB these days and all RDBMS work pretty much the same, so anything you learn is fairly generic knowledge. CREATE TRIGGER <trigger_name> ON <table_name> FOR INSERT AS DECLARE @pk int DECLARE @link varchar(20) SELECT @pk = (SELECT pk_id FROM Inserted) SELECT @link = (select substring(birthdate,1,2) + substring(birthdate,4,2) + substring(birthdate,7,2) + right(ssn,4) FROM Inserted) UPDATE <table_name> SET linkid = @link WHERE pk_id = @pk ok, I am rusty at SQL Server, I have been using mySQL for a while, so this may not be quite right, but should give you the idea. Basically the "As" part will execute whenever a row is inserted. the "Inserted" field is special temp table sql server makes with fields from last insert. replace "pk_id" with your primary key field http://www.informit.com/guides/content.asp...&seqNum=70&rl=1 what polices and guildlines do you have to follow that prohibit correct DB design?

That is correct... trigger. The language of SQL Server is called "Transact-SQL" or "T-SQL" syntax is something like CREATE TRIGGER <trigger_name> ON <table_name> FOR INSERT AS <tsql code here> but if you are just trying to make a link for the table you should use a "dumb" primary key, meaning it is only unique identifier, not related to row data in any way. Then you reference this as foreign key in child table. I will elaborate if you are interested.

No inconvenience, that's what MSFN is for! look at "source" in browser you will see you still have many blank spaces. It will wrap on the first one it Finds. try the php str_replace() function to convert all " " to you also should pad your individual data item strings to standard length so columns line up, else put them in a table. http://us2.php.net/manual/en/function.str-replace.php $htmlout = "1 0000-00-00 Missouri Bad Jackson 3.3113E+11 3208 4 S Fork Bad River ......." $htmlout = str_replace(" ", " ", $htmlout); echo $htmlout

there are instructions on comcast web site. you need to enable frontpage extensions in your comcast account, then you open web in frontpage as "https://home.comcast.net/~username" (your username here of course, but you need the tilde ~)

That's not funny at all.

That's not quite right. You can boot and do clean install from upgrade CD, it will just ask you to insert your previous version cd if it doesnt find it on the drive. XPCREATE works fine with upgrade CD.

another command line tool is qres http://www.snapfiles.com/freeware/system/fwcprompt.html

no, use one for each space you want to insert. The browser is wrapping on the blank space, if you replace them all with it won't wrap and will display horiz. scrollbar.

try replacing the blank spaces in your output string with non-breaking spaces ( ) That will stop it from wrapping. 1 0000-00-00 Missouri Bad Jackson 3.3113E+.... etc.