find out how you either misspelled or what table you are actually trying to
insert into...
or make sure you are using the correct datasource...
Terry Bader
IT/Web Specialist
EDO Corp - Combat Systems
(757) 424-1004 ext 361 - Work
[EMAIL PROTECTED]
Check your datasource "YALLA" to be sure that the database it points to
contains the table "PeopleDirectory"
Sincerely yours,
Jim Gurfein
President, CEO
RestaurantRow.com, Inc.
http://www.restaurantrow.com
914.921.3200 ext 101
914.921.9190 fax
~~~
Heidi,
It looks like the table you are trying two insert into (PeopleDirectory) does not
exist in the SQL database represented in the
YALLA datasource.
Heidi Belal wrote:
>
> can some one tell me the reason for this error and how
> i can solve the problem?
> Thanks!
>
> Error Diagnostic Infor
At 10:36 AM 8/3/2004, you wrote:
>I am reading an excel file into a table. There is a field in the table for # of datapoints that I need to get from counting the records in another table that match the test number. Tables are
>
>tblPlan
>strTestNo
>intDpCount
>
>tblDatapoints
>intDatapointID
>str
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
try using...
mailto:[EMAIL PROTECTED]]
Sent: Friday, January 12, 2001 7:44 AM
To: CF-Talk
Subject: need help..
Hi all,
I have a form field and i want to check if there is any special
character
typed in instead of alphabets and numbers.
Is there a
You can do a Find("/",var,1)
-Original Message-
From: Vani Kolli [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 12, 2001 9:44 AM
To: CF-Talk
Subject: need help..
Hi all,
I have a form field and i want to check if there is any special character
typed in instead of alphabets and number
You can use the REREPLACE() function in CF (RE Stands for Regular
Expression).
For example, to remove non-numerics from a string use:
You can use almost any regular expression comands in there.
Russel
Russel Madere, Jr. S
Check into ReFind
At 9:44 AM -0600 1/12/01, Vani Kolli wrote:
>Hi all,
>
>I have a form field and i want to check if there is any special character
>typed in instead of alphabets and numbers.
>Is there any tag in cf to find it.
>
>I remember doing it in Perl, but not sure of cf.
>
>Any help woul
you could use REFind. try
this will be true if there is a nonalphanumeric character in the form field.
chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com
-Original Message-
From: Vani Kolli [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 12, 2001 10:4
Use a regular expression. REReplace() can replace all characters not
matching those specified.
Example: REReplace(mystring, "[^a-zA-Z0-9]", "", "ALL")
If you just want to find the character use REFind().
Example: REFind("[^a-zA-Z0-9]", mystring, 1)
Using REFind(), you'll have to loop over the
You can use refind() to look for it. If you create a regex like
"[^a-zA-Z0-9]" to look for things that are not in that character range, and
then do logic based on that. Like so:
Less server processing to do it client-side, though. In the form field, you
could put a function onChange, like so
Thanks to all who responded but i wanted to find the first character is not
a special chracter and if it is, i want to delete that character.
If i have the special character in the beginning it shows the html code whne
i use this value in the other page
And i am using not
Thanks
Vani
Hi Russel,
Does this replaces all special characters to null or only the specified ones
??
Thanks
Vani
-Original Message-
From: Russel Madere [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 12, 2001 11:04 AM
To: CF-Talk
Subject: RE: need help..
You can use the REREPLACE() function in
riday, January 12, 2001 8:16 PM
To: CF-Talk
Subject: RE: need help..
Hi Russel,
Does this replaces all special characters to null or only the specified ones
??
Thanks
Vani
-Original Message-
From: Russel Madere [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 12, 2001 11:04 AM
To: CF-Talk
Su
ok, I think I found itsorry
- Original Message -
From: "Doug Brown" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Friday, September 08, 2006 12:35 PM
Subject: Need help!!
> Ok, I finally bowed down to the gods of CF and installed CFMX. I was
running CF5 and had installed the odbc conne
I see in adobe help they say that Connector/J version 3.1.11 and higher
cannot be used with CFMX. Is this still the case? How bout 5
- Original Message -
From: "Doug Brown" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Friday, September 08, 2006 12:35 PM
Subject: Need help!!
> Ok, I fina
>I see in adobe help they say that Connector/J version 3.1.11 and higher
> cannot be used with CFMX. Is this still the case? How bout 5
>
>From Adobe, updated 8/1/06:
http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_19170
"Connector/J version 3.1 release 3.1.11 or 3.1.12 cannot be us
anson" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Friday, September 08, 2006 1:28 PM
Subject: Re: Need help!!
> >I see in adobe help they say that Connector/J version 3.1.11 and higher
> > cannot be used with CFMX. Is this still the case? How bout 5
> >
age -
From: "Doug Brown" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Friday, September 08, 2006 12:36 PM
Subject: Re: Need help!!
> Josh, thanks for the reply. I am a little confused as to installing the
> connector under windows. How is this accomplished as far as c
> I don't know if you need to do anything Windows ODBC related since
> Connector/J is JDBC -- I didn't need to do anything
> additional to get it
> working with CF besides dropping in the JAR file and
> restarting CF
Same here.
---
This transmission may contain informat
gt;
To: "CF-Talk"
Sent: Friday, September 08, 2006 1:51 PM
Subject: Re: Need help!!
> I don't know if you need to do anything Windows ODBC related since
> Connector/J is JDBC -- I didn't need to do anything additional to get it
> working with CF besides dropping in the
Your JDBC url should look like:
jdbc:mysql://localhost:3306/yourdbnamehere (no []'s)
Driver class should be:
com.mysql.jdbc.Driver
-- Josh
- Original Message -
From: "Doug Brown" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Friday, September 08, 2006
Thanks alot for the help!! They should make stuff a little more
understandable on adobe site.
- Original Message -
From: "Josh Nathanson" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Friday, September 08, 2006 2:41 PM
Subject: Re: Need help!!
> Y
Doug,
Does your log file look like like this? localhost:3306?
at org.gjt.mm.mysql.MysqlIO.init(Unknown Source)
at org.gjt.mm.mysql.Connection.connectionInit(Unknown Source)
at org.gjt.mm.mysql.jdbc2.Connection.connectionInit(Unknown Source)
at org.gjt.mm.mysql.Driver.connect(U
> I need to create a form with 15 minutes blocks that
> people can choose a block to sign up for. The page
> is receiving a variable for the number of blocks the
> person needs (1 =15 mins, 2 =30 mins, etc) and it
> has to be able to check the datasource if those
> spots are already taken for the
Thanks Justin. That is definitly the road I need to go down.
I went along the same thoughts with the 96 blocks but I couldn't figure out how
to handle the individual users having different block requirements each time
and how to display the form.
Frank
~
when you are working with cf8 ajax ui controls, you should either have
all your js in an external file, or, if you have js in the same file,
your js functions must be declared as
functionname = function(arguments) {
}
not
function functionname(arguments) {
}
hth
Azadi Saryev
Sabai-dee
>when you are working with cf8 ajax ui controls, you should either have
>all your js in an external file, or, if you have js in the same file,
>your js functions must be declared as
>functionname = function(arguments) {
>...
>}
>
>not
>
>function functionname(arguments) {
>...
>}
>
>hth
>
>Azadi Sa
>when you are working with cf8 ajax ui controls, you should either have
>all your js in an external file, or, if you have js in the same file,
>your js functions must be declared as
>functionname = function(arguments) {
>...
>}
>
>not
>
>function functionname(arguments) {
>...
>}
>
>hth
>
>Azadi Sa
Sorry I am not sure what you actual problem is.
But can I ask why you are using IFrames? Cfdiv maybe just as good for
your needs:-)
On Mon, Mar 24, 2008 at 3:52 AM, Don L <[EMAIL PROTECTED]> wrote:
> >when you are working with cf8 ajax ui controls, you should either have
> >all your js in an e
>Sorry I am not sure what you actual problem is.
>
>But can I ask why you are using IFrames? Cfdiv maybe just as good for
>your needs:-)
Hey Andrew,
I have to use IFrames inside a CFWINDOW because I need to allow multiple
instances of a WYSIWYG editor (which I've created and is working
outside/
sorry think my code got a bit mixed uo, here are the 2 files
values passed thru
SELECT pol_ID, pol_Question, pol_Category, pol_Status
FROM pol_Poll
WHERE pol_ID = #URL.PollID#
SELECT ans_ID,ans_Ans
FROM ans_Answer A
WHERE ans_pol_ID = #url.PollI
You can't have a line graph with more than one line.
===
Raymond Camden, Principal Spectra Compliance Engineer for Macromedia
Email: [EMAIL PROTECTED]
Yahoo IM : morpheus
"My ally is the Force, and a powerful ally it is." -
ursday, January 03, 2002 2:35 PM
Subject: RE: Need help with
> You can't have a line graph with more than one line.
>
> ===
> Raymond Camden, Principal Spectra Compliance Engineer for Macromedia
>
> Email
x27;a lame idea, but it may work
for
you.
-Original Message-
From: Tom Espen Pedersen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 03, 2002 5:34 AM
To: CF-Talk
Subject: Re: Need help with
Is there any other way of doing this kind of graph then ?
any custom graph generators or
-
From: Ron Anderson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 03, 2002 12:34 PM
To: CF-Talk
Subject: RE: Need help with
I haven't found any way using CFGraph...unless MM is producing it soon
(wouldn't that be nice).
We had to drop CFGraph and use CFX GraphicsServer...which is f
riday, January 04, 2002 12:33 AM
Subject: RE: Need help with
> Ron,
>
> Ditto. We do stock charting and tried in vain to create configure cfgraph
> to work for us - we liked it's very clean look - but we continue to use
> CFX_graphics server. It's an excellent product
Check out teratech's site (Michael Smith is the guys name).
Mark
-Original Message-
From: Tom Espen Pedersen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 03, 2002 2:08 PM
To: CF-Talk
Subject: Re: Need help with
Do you know where I can find the CFX_Graphics Server, the s
You can get it from http://www.cfxgraphicsserver.com/
-Original Message-
From: Tom Espen Pedersen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 03, 2002 5:08 PM
To: CF-Talk
Subject: Re: Need help with
Do you know where I can find the CFX_Graphics Server, the search @
developers
why rebuild the wheel, there are plenty of shopping cart apps, that
you could probably hack around to get what you want, and then from
there, you could LEARN alot about application setupjust an idea.
http://www.quilldesign.com/
look for sitedirector, it rocks!
tw
On Wed, 21 Jul 2004 16:29:0
Well if you want them to keep adding line items without refreshing the screen then you could use DHTML to update a layer with each new line item added. At the same time you could add the the line item details to to hidden form field values holding lists of product IDs and quantities via _javascrip
Well there are really two parts to this problem: how the form would work,
and what the interface would look like. One simple way to do it would simply
be to generate a lot of order lines (i.e. more than you need, say 100 or so)
and hide most of them using style="display:none", then just reveal the
Did a stored procedure.
Here is the code:
CREATE PROCEDURE getDpCount AS
/* declare local variables used for fetch */
declare @strPlanTestNo varchar(50)
declare @dpCount int
/* declare the cursor to get each book written
by given author */
declare testno cursor for
select strPlanTestNo
fro
4:01 PM
To: [EMAIL PROTECTED]
Subject: RE: need help..
The particular regex (regular expression) provided will remove all non
digits in the text field. If you want to replace anything that's not a
digit or a letter at the begining of the field you need
--K
-Original Message-
Ferg,
I don't have an aol address however I just went through a similar situation
with aol. Have you visited their postmaster web site.
(http://postmaster.aol.com) They go into detail on this site what they
require in order to completely deliver the message? I know aol a few days
back required a
Ken,
Unless we're talking about cfmail, this is off-topic.
That said, it is very likely that your mail server has been blacklisted
by AOL. This is very common, even among the most innocent of mail servers.
If you've been blacklisted, your mail server's logs will contain a
message with a link
When you generate your url strings, use encrypt() to encrypt the
variables; when you need to reference those url variables, decrypt them
using decrypt()
--
Billy Cravens
[EMAIL PROTECTED]
Rif Kiamil wrote:
>
> How do I encrypt urls, where do i get info on encrypt urls, just want info
> on enc
l 2000 09:29:15 -0500
From: Billy Cravens <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: NEED HELP Encrypt Url ?
Message-ID: <[EMAIL PROTECTED]>
When you generate your url strings, use encrypt() to encrypt the
variables; when you need to reference those url variables, decrypt the
Could you share your solution with the class?
Steve
-Original Message-
From: Karl Simanonok [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 17, 2000 1:09 PM
To: [EMAIL PROTECTED]
Subject: Re: NEED HELP Encrypt Url ?
Encrypting URL strings is often desirable, but some time ago I tried
Steve,
the cfencrypt, cfdecrypt usage is:
To encrypt/decrypt url (cgi.query_sring) use:
check it
Have fun,
Miro
- Original Message -
From: "Steve Bernard" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 17, 2000 9:47 PM
Subject: RE:
It was
to this that I was asking for more information.
Regards,
Steve
-Original Message-
From: Mirek Hryckowiak [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 26, 1998 5:44 PM
To: [EMAIL PROTECTED]
Subject: Re: NEED HELP Encrypt Url ?
Steve,
the cfencrypt, cfdecrypt usage is:
CTED]]
Sent: Tuesday, July 18, 2000 8:47 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: NEED HELP Encrypt Url ?
I know how to use cfencrypt/cfdecrypt. In the posting to which I responded,
Karl, the writer, stated, "I solved the problem by getting rid of the CF
encrypt/decrypt metho
Original Message:
===
Date: Mon, 17 Jul 2000 16:47:57 -0400
From: "Steve Bernard" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: RE: NEED HELP Encrypt Url ?
Message-ID: <[EMAIL PROTECTED]>
Could you share your solution with the class?
Steve
==
from my personal experience:
- number of domain names isn't an issue - I'm using ULTRADNS for the DNS
instead of the DNS my datacenter provides due to the infrastructure and the
fact that I can make changes in real time (and their site is CF/Fusebox!)
- if you're in a major metropolitan area, go w
Compaq 1850r .. single, maybe dual 400-450 proc, 512MB ram, 3x9.1GB SCSI
drives on raid 5 with a good controller..
Nice machine, fairly cheap if you can find a decent one on eBay or
something. It only uses 3U of space, and can take 2 hot-swap power supplies
as well, reducing downtime if you nee
and storage arrays that went for peanuts. You're going to see a LOT of this
stuff on eBAy in the near future.
Jim
- Original Message -
From: "Justin Scott" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, November 02, 2001 8:55 PM
S
Justin Scott wrote:
> Compaq 1850r .. single, maybe dual 400-450 proc, 512MB ram, 3x9.1GB SCSI
> drives on raid 5 with a good controller..
I would say that is insufficient RAM. Look at all the services that will
be running:
OS stuff (50 MB)
ColdFusion (100 MB or more)
IIS (100 MB or more)
DNS
Look at cfx_http in the taggallery...
Justin
>>-Original Message-
>>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>>Sent: Wednesday, April 18, 2001 2:50 PM
>>To: CF-Talk
>>Subject: Need Help for cfhttp
>>
>>
>>
>>
>>
>>Hi,
>>
>>I have a cfm page that needs access to https si
I would get rid of the NAME and "delimeter" attributes and try simply
"getting" the file first. Does that work? Can you get the raw contents of
the file (without putting it into a query).
Also, is the actually pointed at a filename? Or does it point to a
cfm page that delivers up the file? If
well first off the only two valid characters for the delimiter are a tab or
comma and you are using a semi-colon.
Here is the excerpt from CF Help:
GET file into a query -- To download a file in a ColdFusion page so that a
query can be built using the file, the file must be either comma-separate
In fact, by adding the textqualifier attribute I am now able to see the content of the
text file:
http://www.hud.gov/offices/pih/pha/received/#fiscalyear#/#fieldoffice#-#fiscalyear#.txt";
delimiter=";" textqualifier="">
And yes, it is pointing to a real text file which in fact contains HTML t
use regex.
-mk
-Original Message-
From: Mitko Gerensky-Greene [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 23, 2002 3:27 PM
To: CF-Talk
Subject: RE: Need help with CFHTTP
In fact, by adding the textqualifier attribute I am now able to see the
content of the text file:
http://w
I've been using it with with CF5. We use their Print Server and WebGrabber app
without problem. Yes you do need to use to use their controls. Sample
code is supplied with the programs. There are also ASP code samples that are easily
converted to CF.
Shawn Richards
Rich Digital Solutions,
SELECT *
FROMTheTable
WHERE TheTextField LIKE '%#SearchString#%'
And yes, you will want to 'encode' the variable inside a tag,
otherwise you'll wake up one morning with "hacked by the chinese" on your
home page.
Adam.
> -Original Message-
> From: Eric Homa [mailto:[EMAIL PROTE
Jake McKee wrote:
>
> I'm trying to find the highest rated items (max of 10 and based on an
> average of all the times that item was rated). Since many of the top
> rated items will have the same rating, and I need to choose the "top"
> 10, I further want to base it on traffic to that item.
>
>
Jake. wrote:
>> SELECT
>> AVG(r.rating) AS rating,
>> r.LinkIDFK2
>> FROM
>> Reviews r INNER JOIN Traffic t
>> ON r.LinkIDFK2 = t.LinkIDFK
>> GROUP BY
>> LinkIDFK2
>> ORDER BY
>> rating DESC,
>> t.Hits DESC
>>
>> Depending on your database you can usually limit the numer of
>> results by
Jake. wrote:
>>SELECT
>> AVG(r.rating) AS rating,
>> r.LinkIDFK2
>>FROM
>> Reviews r INNER JOIN Traffic t
>> ON r.LinkIDFK2 = t.LinkIDFK
>>GROUP BY
>> LinkIDFK2
>>ORDER BY
>> AVG(r.rating) DESC,
>> t.Hits DESC
>
>
> Sorry, same problem:
>
> [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsof
first, try rebooting the server...then try deleting the cfclasses.
---
Exciteworks -- expert hosting for less!
http://exciteworks.com
specializing in reseller accounts
chad wrote:
> I have a site that generates a couple of graphs (CFMX Server), the
> graphs get created correctly and are stored
I guess they are part of the CFFM file manager of Rick Root...
Greetings / Grüsse
Gert Franz
Customer Care
Railo Technologies GmbH
[EMAIL PROTECTED]
www.railo.ch
Join our Mailing List / Treten Sie unserer Mailingliste bei:
deutsch: http://de.groups.yahoo.com/group/railo/
english: http://groups.ya
AND
color/style information.
Thanks,
Mike
-Original Message-
From: Gert Franz [mailto:[EMAIL PROTECTED]
Sent: Monday, May 14, 2007 9:22 AM
To: CF-Talk
Subject: Re: Need help finding cffm.resourceKit.Msg.
I guess they are part of the CFFM file manager of Rick Root...
Greetings / Gr
kondo nugroho wrote:
> We have a website hosted in a server with Windows 2003 (english version),
> Coldfusion 5 (english version) and msSQL 2000 (english version)
> Most of the records are in Japanese, which is written into the database
> field (nvarchar) using windows default encoding.
> I am not
kondo nugroho wrote:
> Most of the records are in Japanese, which is written into the database
> field (nvarchar) using windows default encoding.
no, cf5 doesn't know anything about encoding, it simply passed whatever data
you
add through to the db. your data is for sure mangled.
> Our problem
Thanks. for all your input... it really helps me.
from your explanation... you make it clear that there is NO WAY cf7 query in
a way like cf5 does ?
Our website... www.ilovesmart.com is quite active...
so... at this moment... we do not want to take the risk to convert from cf5
to cf7
Unless we c
Create a dsn on your machine pointing to there sql server and the database
for starters.
-Original Message-
From: Dominic Hess [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 24, 2001 1:11 AM
To: CF-Talk
Subject: Need Help with SQL!!
Ok having a big problem...
Need to get away from
First try the native tools supplied with SQL Server, which would be
Enterprise Manager if you like a graphic interface, or Query Analyzer if you
like a command line. Both of these tools are found in the Programs/SQL
Server 7.0 menu.
Visual InterDev is a cluttered interface and will just introduc
lk" <[EMAIL PROTECTED]>
Sent: Tuesday, January 23, 2001 7:46 PM
Subject: RE: Need Help with SQL!!
> First try the native tools supplied with SQL Server, which would be
> Enterprise Manager if you like a graphic interface, or Query Analyzer if
you
> like a command line. Both of
you can do it with a cfquery:
CREATE TABLE Country
(
CountryID Integer Identity Primary Key,
Country VarChar(50),
Code_2 VarChar(2),
Code_3 VarChar(3),
Code_N
Very good I didnt think of that one.
-Original Message-
From: Dick Applebaum [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 23, 2001 11:41 PM
To: CF-Talk
Subject: Re: Need Help with SQL!!
you can do it with a cfquery:
CREATE TABLE Country
(
CountryID
ed a connection though.
-Original Message-
From: Dick Applebaum [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 23, 2001 11:41 PM
To: CF-Talk
Subject: Re: Need Help with SQL!!
you can do it with a cfquery:
CREATE TABLE Country
(
CountryID I
yeah thats what im going to do, screw it ill just make my own control panel
to add tables and remove them. Thanks for the email!
- Original Message -
From: "Dick Applebaum" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, January 23
If the ISP will let you have access with enterprise manager, get the
username and password for your sql server. Then go to Microsoft's home page
and download the developer's edition of SQL server and install it on your
own machine. Then you can connect to the sql server and create tables
easily.
ction though.
>
>-Original Message-
>From: Dick Applebaum [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, January 23, 2001 11:41 PM
>To: CF-Talk
>Subject: Re: Need Help with SQL!!
>
>you can do it with a cfquery:
>
snip
~~~
>
>
> CREATE TABLE Country
>(
> CountryID Integer Identity Primary Key,
> Country VarChar(50),
> Code_2 VarChar(2),
> Code_3 VarChar(3),
> Code_Numeric
Dominic, you go to www.factorxsoftware.com/download.cfm and download my WebSQL SQL
Server Tool. This is a web based SQL Server Manager. It is still in beta but you can
add tables, view data, add/modify stored procedures. I am still in the process of
finishing the app but it can help you as it s
At 06:24 PM 4/2/00 -0700, you wrote:
>
> SELECT *
> FROM y where #emp_id# LIKE
> '#search_criteria#%'
>
Assuming that table Y is related to X through the foreign key emp_ID you
could do this:
SELE
At 09:40 PM 4/2/00 -0400, you wrote:
Error in previous transmission: The first solution should actually read:
SELECT *
FROM y where emp_id LIKE '#SEARCH_QUERY.emp_id#'
>Assuming that table Y is related to X through the foreign key emp_ID you
>could do this:
>
>
>SELECT *
>FROM y where emp_id
I think the bigger question if you're using "CONTAINS" then have you setup
full-text indexes on the appropriate columns?? or are you going to use the
inefficient LIKE '%string%' approach?
Something to think aboutand the answer (combined with what database you
use) will determine the final
Stevenson [mailto:[EMAIL PROTECTED]
Sent: Friday, April 15, 2005 3:33 PM
To: CF-Talk
Subject: Re: Need Help Parsing Text
I think the bigger question if you're using "CONTAINS" then have you setup
full-text indexes on the appropriate columns?? or are you going to use the
inefficient
here goes ;-)
AuhtorList should now be GEISEMAN,SMITH
AbstractList should now be CAT,DOG,FISH
Then just loop over each list and create your SQL ;-)
Cheers
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.
Thank you SO much!!
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: Friday, April 15, 2005 3:49 PM
To: CF-Talk
Subject: Re: Need Help Parsing Text
here goes ;-)
AuhtorList should now be GEISEMAN,SMITH
AbstractList should now be CAT,DOG,FISH
Then
It's not pretty and missing cfqueryparams but ...
author LIKE %#listgetat(author, i)#%
or
or
abstract LIKE %#listgetat(abstract, i)#%
or
)
should spit this out...
SELECT whatever from tbl_something
where
(
autho
no problem...but I should mention I didn't test thatbut you can probably
see what I was doing ;-)
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electr
Athelene,
Copy/paste this into a CFM page and hit it with a browser...
You may like what you see. :)
J
select *
from tbl_whatever
where lastname in (#listOneEnd#)
and
abstract in (#listtwoend#)
On 4/15/05, Gieseman, Athelene <[EMAIL PROTECTED]> wrote:
> I have a text field that cont
OOPS, correction below... I got the AUTHOR column named incorrectly... sorry.
If you want, you can view it here, too:
http://w2ksrv1.neo.servequake.com/tmp/ath.cfm
I'll leave it up for a few days...
Laterz,
J
select *
from tbl_whatever
where author in (#listOneEnd#)
and
abstract in (#
Thank you very much!
-Original Message-
From: Jared Rypka-Hauer - CMG, LLC [mailto:[EMAIL PROTECTED]
Sent: Saturday, April 16, 2005 11:11 AM
To: CF-Talk
Subject: Re: Need Help Parsing Text
OOPS, correction below... I got the AUTHOR column named incorrectly...
sorry.
If you want, you
NO PROBLEM!
This kinda thing is just fun... :)
The only gotcha here is that it's dependent on comma-space to set the
double-pipe delimiter... and I didn't see it until I looked at the
string in a fixed-width font. ;)
If your format is really consistent, where "', A" is a reliable
delimiter, you'
I cant tell you why this is the case, but if i lowercase the var
"firstname" in the gridcolumn and the bind var then it works fine.
Here is my example code from yours.
artists = queryNew('firstname,lastname,city','varchar,varchar,varchar');
queryAddrow(artists,1);
querySe
Ok so I posted my code after I changed it back to camelCase to prove
that was why it broke. here is my code.
artists = queryNew('firstname,lastname,city','varchar,varchar,varchar');
queryAddrow(artists,1);
querySetCell(artists,'firstname', 'simeon');
Hey,
OK< I tried this and still have no luck. :( Ah Why is this happening??
Is there something else I might be doing wrong? Is there another way to
accomplish this same task? Anyone? HELP
Kevin
Rose Valley Soaps
http://www.rosevalleysoaps.com
-Original Message-
Ok so I posted my
Just for thought...lots of people (including me) have multiple email
addresses and use them interchangeably.
Maybe if the email address was also the user name that would reduce the
chance of people using multiple email addresses?
-Original Message-
From: Aaron Roberson [mailto:[EMAIL PROT
1 - 100 of 504 matches
Mail list logo