That would work if it was in the query string. He's trying to URL
encode a query string as part of a larger string... not the query
string he's receiving. But honestly it shouldn't be necessary, since
most (all?) clients will handle that for you.
-dhs
Dean H. Saxe, CISSP, CEH
[EMAIL
I was actually just looking for a regex solution to parsing up many
lines of text, some of which contain urls. And if those url's have a
space on the query string to replace those spaces on the query string
with the + character.
I could use CF but, was trying to just get the regex. Possbly using
Don't need the lookarounds
Use this regex and save $1 and $3 /(a.*?http://([^/]+/)+[^?]+?)([^=]
+=\S+\s+\S?)/gx
Then use this on $2 to replace the spaces s/\s/+/gx.
Then push $1 and $2 back together to get your whole string.
That's the perl way...
-dhs
Dean H. Saxe, CISSP, CEH
[EMAIL
FWIW, this is an untested regex from off the top of my head...
-dhs
Dean H. Saxe, CISSP, CEH
[EMAIL PROTECTED]
[T]he people can always be brought to the bidding of the leaders.
This is easy. All you have to do is to tell them they are being
attacked, and denounce the pacifists for lack of
Good luck, the regex might need a bit of tweaking. Also, I didn't
anchor it to line beginnings/endings, since I don't know the data
format well enough to know if that is an issue for you.
-dhs
Dean H. Saxe, CISSP, CEH
[EMAIL PROTECTED]
Here in America everything is bought and sold, you
I use this: http://regexlib.com/RETester.aspx
On 6/5/07, John Mason [EMAIL PROTECTED] wrote:
Is there a good regex testing tool out there. I tend to test straight off my
cf code which is cumbersome at times.
John
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
RegEx coach
-dhs
Dean H. Saxe, CISSP, CEH
[EMAIL PROTECTED]
What difference does it make to the dead, the orphans, and the
homeless, whether the mad destruction is wrought under the name of
totalitarianism or the holy name of liberty and democracy?
--Gandhi
On Jun 5, 2007, at
I apologize for the OT post, but I'm getting frustrated.
I am attempting to use a UDF to split a varchar (comma delimited list of
ints) in an IN clause in a SQL statement, and I'm not able to get the SQL
statement to pass a Table field to the UDF.
I'm hoping someone sees a glaring error, or
MessagePaul,
There is already an open source function in SQL Server to do this for you:
http://www.4guysfromrolla.com/webtech/031004-1.shtml
They explain how to put it together.
Here is the function creation for how I put it together from their explanation:
if exists (select * from
Sure it is, Teddy. 1NF requires atomic data. Data with formatting,
such as a list, is not atomic and therefore not 1NF.
http://databases.about.com/od/specificproducts/a/firstnormalform.htm
-dhs
Dean H. Saxe, CISSP, CEH
[EMAIL PROTECTED]
Here in America everything is bought and sold, you
Teddy,
Any idea why do I get an error in Query Analyzer :
SQL Statement
SELECT *
FROM dbo.ORDER_ITEMS oi LEFT OUTER JOIN
dbo.AP_translation tr ON tr.option_id IN
(select convert(int,Value) from dbo.Split(oi.OptionIDs, ','))
WHERE (oi.Order_ID = 12387)
Maybe I missed something, but why wouldn't you just use a cfqueryparam with a
type of sql_int and list=yes.
- Original Message
From: Paul Morton [EMAIL PROTECTED]
To: discussion@acfug.org
Sent: Tuesday, June 5, 2007 1:36:40 PM
Subject: [ACFUG Discuss] OT: SQL help
Message
I
Why is that? You don't still believe that stored procedures always perform
better do ya? ;)
- Original Message
From: Teddy R Payne [EMAIL PROTECTED]
To: discussion@acfug.org
Sent: Tuesday, June 5, 2007 2:09:40 PM
Subject: Re: [ACFUG Discuss] OT: SQL help
Message
You use it in an
Or he hasn't yet been bit by management that says they need to change
RDBMS... migrating stored procs is hell. Migrating CF code is much
easier, in general. It also keeps the business logic in one layer of
code, not spread across the code and DB.
-dhs
Dean H. Saxe, CISSP, CEH
[EMAIL
Speaking of OT SQL help ...
If there are any database gurus out there that could throw me a bone and
send me some sql code that would detect and remove foreign key relationships
from tables (sql server 2000). If you're thinking why would I want to do
this? it is because this database gets
So you'd rather have no foreign key relationships and let the DB get
all out of whack rather than figure out the DTS issues? I think
you're looking at the wrong problem, I'd spend my time figuring out
the DTS and making sure it works correctly.
-dhs
Dean H. Saxe, CISSP, CEH
[EMAIL
Fair enough...
Why not use the metadata in the DB to identify all of the FKs and
then write a script to drop them?
-dhs
Dean H. Saxe, CISSP, CEH
[EMAIL PROTECTED]
[U]nconstitutional behavior by the authorities is constrained only
by the peoples' willingness to contest them
--John
Normally I would agree ... but this is a judgment call for other reasons.
Also this is not the real copy of the database and the data being served
will not be affected by it.
_
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dean H. Saxe
Sent: Tuesday, June 05, 2007 4:02
Check out the sysobjects tables. Information_schema is a standard
schema implemented by most RDBMS to handle a lot of the metadata, but
I don't think it contains metadata on FKs.
-dhs
Dean H. Saxe, CISSP, CEH
[EMAIL PROTECTED]
Dissent is the purest form of patriotism.
--Thomas
For SQL Server 200, the master database holds the information for the metadata
for databases on that particular server instance.
If you have access to this database, there should be some views pre-made by SQL
Server that should show some of this information.
Teddy
- Original Message
Thanks both Teddy and Dean. I was hoping for a quick way to do this but I'm
actually almost finished doing it one table at a time manually with the GUI.
Still this info is good to know.
Dusty
_
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Teddy R Payne
Sent: Tuesday,
21 matches
Mail list logo
