LogicMechanic
Last Activity: Mar 24 '09, 06:56 PM
Joined: Jan 30 '09
Location:
-
ALTER TABLE mytable ADD columename int NOT NULL -
Constraint on existing table, multiple columns
I need to add a constraint to every varchar column in an entire database to not allow '<script>' to be inserted or updated. Any resource you know of that would explain how I would go about this? I was thinking to program it with a stored procedure. Something like, get a table name, get all the varchar columns in that table, build the constraint statement on the fly, execute the statement, go to the next table. If I had that, then I could save... -
I will try that. Is there anyway to preserve the binary stream without altering it in anyway?Leave a comment:
-
Dim iBytes As Integer = ServerSocketFor Client.Receive( byteArray, byteArray.Lengt h, 0)
Dim MessageFromClie nt As String = Encoding.ASCII. GetString(byteA rray)
This is what accepts the incoming stream. Do you have a better idea?Leave a comment:
-
SMTP listener corrupting HTML
I did not write the smtp, I canabalized some code. It is working nicely, listening on a port for incoming connections, responding well, and accepting the incoming byte stream of the message on a socket. When it gets to the MAIL command, I have to parse out the from and to email addresses to format the file for relaying. (I have to add x-sender: email@address.c om and x-receiver: email@address.c om to the...Leave a comment:
-
SMTP listener corrupting HTML
I have an SMTP listener that accepts incoming connections and routes the message to a folder using FileStream. I have to add x-sender: email@address.c om and x-receiver: email@address.c om to the first two lines of the file so it can be put in a pickup folder for relay later. It seems as though this way of handling the incoming stream is corrupting the HTML in the email message body. Does anyone have a clue what I am doing wrong or a suggestion that...
No activity results to display
Leave a comment: