Has anyone used the cf_avery tag that is suppose to format the information
into mailing labels?
The directions sounded simple enough- so I did a simple query and set it out
to display. I got an error. I can't even get their example.cfm page to
work. Instead I get a pop up box claiming: IE cannot
I am using client variables for some of my applications. I have done the
recommended way and made a client variable database to store all the info.
(on a MSSQL db) It is the only info stored there.
I just noticed today that this db is over 10 gig big! It's not like there
are many rows of
Archive: http://www.houseoffusion.com/lists.cfm/link=i:4:166634---I use some _javascript_ validation for one page where users can change account
information.
I want to add a validation that alerts them if the password is less than 6
characters long
I have this but it doesn't work. Here's the chunk
I have a conference application.
On the admin page the user can send an email to notify the presenter on if
their proposal has been accepted.It then shows in the database if the
person was notified and the date.
This piece doesn't seem to be working properly.
What is working:
The query pulls all
Subject: activePDF
From: Phillip B [EMAIL PROTECTED]
Date: Thu, 10 Jun 2004 10:01:32 -0500
Thread:
http://www.houseoffusion.com/cf_lists/index.cfm/method=messagesthreadid=0f
orumid=4#166130
Any one use this with CF and can answer a few questions for me?
Phillip B.
[Todays Threads]
[This
Phillip,
I'd be glad to answer a few questions. We use activepdf for several
projects.Feel free to contact me off list.
Janine
Subject: activePDF
From: Phillip B [EMAIL PROTECTED]
Date: Thu, 10 Jun 2004 10:01:32 -0500
Thread:
I just set up a test mx box with a FB3 application.
Used the analyzer to check my cf5 pages- all came up clean
However, the browser is blank when I call the pages.
Any ideas of what I missed when I did the setup?
Thanks,
J
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
On a phone number field I want to make sure that users haven't added ()-.
I figure the easiest way is to strip it off before entering it into the
database.
How would I set that?
Thanks,
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
I've been asked if we can put sql/cfmx all on one box.This is to be set
outside our company firewall.
(We currently have a best practices case set up behind the firewall on our
intranet. This 2nd one would be for non-sensitve database information)
I need to make a reply/case/recommendation on
-Original Message-
From: Mickael [mailto:[EMAIL PROTECTED]
Sent: Monday, December 15, 2003 10:28 AM
To: CF-Talk
Subject: Problems with Nulls
Hello All,
I am running in to a problem on something that I do locally on our intranet.
I query one database(SYBASE) then load the data that I need
Ok this is a new one for me!I have a table that users add plans to.
Because each section of the plan can be extensive each field is 4000
characters long.
I have one user who is having a problem.He said when he went to edit the
last field e received the following error:
[Microsoft][ODBC SQL Server
Hey is there a way to do a dynamic in statement for a stored proc in
sql2000?
I keep getting errors when I change my proc to a simple = to an in
statement. (or more precisely when I choose more than 1 options from the
select box) so I assume it's how it's being sent?? Maybe in the cf part of
how
go to www.tek-tips.com http://www.tek-tips.comlook under sql they have a
pretty decent keywork search.
I've seen good stuff on their site dealing with these type of issues.I'd
dig around and give specific data but have to go to a late meeting-
-Original Message-
From: Cantrell, Adam
If you're using Access2000 you'll be able to use their uplink wizard.It
allows you to move the tables to sql and to even keep them in your access
database.
Now last time I used this product was Sql 6.5- years ago.There was some
weirdness that I would test for if I were you.Make a backup of a table
I have a page that the users wanted multiple textarea fields that could be
spell checked.They also wanted to be able to review all of their previous
work as they were submitting it AND for the page to advance to the next box.
To do that plus to keep it from being a mess of huge textarea boxes
this with multiple
versions of MS Word?I know it won't work for the Mac user - he's ok
with that, but the MS Word support has to be top notch.
Why can't they just learn a little HTML! Hehe
-Original Message-
From: Janine Jakim [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 13
Have an application with a bunch of input boxes.The users want to be able
to do snazzy things as if it's a word document- underline, bold, change font
size and/or type for certain parts.
Is this possible?
They then want to output it to a word doc. (I do know that's doable)
Thanks,
J
[Todays
http://www.interactivetools.com
Easy use
- Original Message -
From: Janine Jakim
To: CF-Talk
Sent: Thursday, November 13, 2003 12:30 PM
Subject: Users want to format text
Have an application with a bunch of input boxes.The users want to be
able
to do snazzy things as if it's a word
My guess there's something wrong with this line
cfset theReport = #ReportName#'.CFM'
This isn't a database command so you don't need a to concatonate the 2
together.
To check do a CFOUTPUT#theReport#/#ReportName#/CFOUTPUT
That'll probably show you the error as the report name probably isn't what
One way to view duplicates is by using a having clause in your query.It
means that there's at least one id/something that will help you know that
the record is a duplicate.An example of this sql is:
select emp_ID, departmentid
from employees
GROUP BY emp_ID, departmentid
having count(emp_ID)=2
Ok can someone help here. I'm getting the following error in my cf
application log:
Error,1344,10/28/03,09:46:08,,ODBC Error Code = 22005 (Error in
assignment)P [Microsoft][ODBC SQL Server Driver]Invalid character value
for cast specificationPP SQL = storeproc_SaveComment
Try not to use *, especially on multiple tables. And you need to link in
your customers table somehow or you'll have a complete mess...
Do something like
cfquery name=Getcustomer datasource=printprices
SELECT Lastname, firstname, c.customerid, o.orderid, b.booktitle
FROM customers c inner join
Mark,
What I did with something similar was to add them together for the ouput and
set a character return between each paragraph.(in fact yours sounds a bit
simpler since you have 3 distinct paragraphs- I had a multitude of various
paragraphs with variable length!
So do this:
CFSET
Get rid of the null=yes. That is setting it to ''.
-Original Message-
From: Bosky, Dave [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 03, 2003 10:06 AM
To: CF-Talk
Subject: Returning value from a stored procedure?
Are there any SQL guru's that can help me with this stored procedure?
Ps.
Guess I should have rewritten this for you
for an out variable this is all you need- no dbvarname either- that goes
with the in type. for type=in you need dbvarname, value, cfsqltype.
for type=out use cfsqltype, variable.
Also don't use the null=yes unless you KNOW for a fact that it will be
: Janine Jakim [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 03, 2003 10:08 AM
To: CF-Talk
Subject: RE: Returning value from a stored procedure?
Get rid of the null=yes. That is setting it to ''.
-Original Message-
From: Bosky, Dave [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 03, 2003
On my pages I use timeout in 15 minutes if no activity
Well on an IMac the battery died. The user decided to stop workingthe
next day the IMac was plugged in and presto there was the page. Is there
anyway around this??
Thanks,
J
Josen,
Your link would hit an action page that would pull up the report. One thing
I would strongly recommend. Have your link open a new window. Depending on
the browser it can/will get stuck in the pdf. A huge annoyance.
Here is a quick example of how the action page works...Hope it helps
I've been searching but haven't found the answer. I have some nested loops
that cf doesn't seem to like- I've read about nested loops off their site,
but still haven't found the answer that is a little more involved...
I need to show data that loops through I think the best way to explain it
is
Last time something like that happened to me I realized that in the stored
proc I put in the wrong number of characters id:
@MacroName VARCHAR(50) instead of @MacroName VARCHAR(500)
-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 17, 2003 1:51 PM
To:
Is there an easy way to force a page break at certain sections?
I have a huge page that people want to view as a long scrollable cfm page
but when printed they want it to start a new page at certain points. (ie:
there may be 5 lesson plans- they'd want each lesson plan on a separate
page/etc.)
I'm wondering if I can do this easily??
I need a numbered loop, but it needs to be roman numerals
i, ii, iii, iv, v, vi, etc
Is there anyway to do that easily or do I need to do the cfif recordcount
blah blah.
thanks,
j
~|
So far all of our applciations have run from our intranet. I just
made a little app that needs to be open on the internet. When I talked to
the system engineer she said:
I will want to investigate security options such as certificates or https.
Once we configure a hole in the firewall,
SELECT *
FROM product A,style B,quantity C
WHERE A.product_id = B.product_id AND
B.style_id = C.style_id AND
ORDER BY A.product,B.style,F.productSize
1. You do not want to use * in this as it's going to pull all fields from
all tables- you don't need the duplicates...
2. I don't know what
I know I know this, yet the answer isn't coming immediately...
I just need to strip the 1st 2 charaters off a field before sending it to
the database. So if this is typed in LV1234 I only want the 1234.
Left won't work because the part on right side can be a variable length
thanks,
j
: Janine Jakim [mailto:[EMAIL PROTECTED]
Sent: Sunday, June 01, 2003 11:24 AM
To: CF-Talk
Subject: Quick question- get rid of 1st 2 characters
I know I know this, yet the answer isn't coming immediately...
I just need to strip the 1st 2 charaters off a field before sending it to
the database. So
Sorry for the ot, but I'm assuming someone can answer this pretty quickly.
How do I make the text of the html look like the traditional 10n power? Is
it an ascii thing?
thanks
j
~|
Archives:
Can I format my excel sheet if I'm using cfcontent or cfheader?
I want to add a word wrap featureI know I can do it in COM, but I don't
want to re-write the page at this time.
Is there anything I can add to make this work?
Thanks,
J
I have an insert query that I can't get to work... when I remove the top
line and run it as a select statement it's fine. when I add the insert
statement I get the error 'invalid number' job_ID is actually a varchar2
field- not a number field.
here's the query
INSERT INTO HR_DEPARTMENTS
I really like the cf_msmenu tag- easy to work with/looks good in lots of
different browsers and works well with Mac (have lots of mac users).
but I'm wondering if there's a way to force this tag to open a page in a new
browser window. I have reports that need to come up in a new window, but
Use between
cfquery name=qDateRange datasource=ds
SELECT * FROM dbo.PaP WHERE test_date BETWEEN #CreateODBCDate (startDate)#
AND #CreateODBCdate (endDate)#
ORDER BY #sort# ASC
/cfquery
-Original Message-
From: Kennerly, Rick H CIV [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 19,
Save as a dts package and then you can edit the information. They have a
visual interface- add dependencies/etc.
I suggest making some db copies and play with it
-Original Message-
From: Dowdell, Jason G [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 18, 2003 9:47 AM
To: CF-Talk
Subject:
Did you find the answer yet?
Why not shift the group by classid to the outside query? do you really need
all the fields from 3 tables?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 13, 2003 4:49 PM
To: CF-Talk
Subject: RE: subquery and group by
That depends- is it a number field or a character field?
Number=no
varchar=yes.
-Original Message-
From: Bosky, Dave [mailto:[EMAIL PROTECTED]
Sent: Friday, March 14, 2003 3:10 PM
To: CF-Talk
Subject: SQL IN command
Is it necessary to wrap the variable ProductsFound which is a list of
Don't you also need to have class_Id in your select clause?
what error are you getting when you just run the subquery by itself?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 13, 2003 4:21 PM
To: CF-Talk
Subject: SQL: subquery and group by a
Maybe I'm making this harder than it is (that's usual for me)
It sounds easy enough-but I am stuck- let me show you my code
I have this:
!---Loop through the narratives for this student---
CFLOOP INDEX= X FROM =1 TO= #NarrativeGet.RecordCount#
CFSET I= ToString(X)
!---Set the fields for
Well the page part was easy enough to do.
It's the setting of the variable that I can't seem to get. I can set and
send the variable to a regular html page fine. It's the setting in
activePDF, which pulls the only the last
#NarrativeGet.EduLeveNarrative[i]#
(looks like each reiteration of the loop
: -Original Message-
: From: Janine Jakim [mailto:[EMAIL PROTECTED]
: Sent: Wednesday, March 12, 2003 11:06 AM
: To: CF-Talk
: Subject: RE: Character count on record count??/
:
:
: Well the page part was easy enough to do.
: It's the setting of the variable that I can't seem to get. I can set
The name needs to be the same with a different value
input type=radio Name=YesORNo Value=Yesnbsp;Yesbr
input type=radio Name=YesORNo value=Nonbsp;No
-Original Message-
From: FlashGuy [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 11, 2003 3:23 PM
To: CF-Talk
I have a page where teachers write narratives on students- this will be sent
to a pdf. I'm wondering about all of the empty space- each page can hold
5000 characters. Depending on the teacher groups a student may have a 1 -6
page narrative...(ie: one teacher may write 200 characters/another
Is anyone using MsMenu?
Is there a way to get the link to open a new window? I haven't had any luck
doing it this way. I'm assuming that it can't be done since the tag is using
js.
Thanks,
J
~|
Archives:
I know checkboxes have been discussed many times- I searched the archives of
hof and cf support and haven't quite found this issue with them so please
forgive me if it's been discussed.
i have a display page that shows about 80 checkboxes- set in a basic table
format. It looks like so
Not much unless you are doing a bunch of data mining(OLAP) and Indexed views
Here's the link
http://www.microsoft.com/sql/evaluation/features/choosing.asp
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 05, 2003 1:38 PM
To: CF-Talk
Subject: sql
Ok- I know this is easy.
I have a PrimaryID that is varchar (it's imported from another database)
My program uses this unique identifier then concatenates other nesseary info
to make a new unique number for the student in other tables.
ie: PrimaryID + SchoolID + SchoolYear
Because it's a varchar I
I find the easiest and quickest way is togo to SQL manager and open the
table in design view.
Click on the Print Screen button.
paste pic onto word doc. Use format Picture to trim the extra space from
the pic.
I like the visual of this way- I get all the design info in a quick easy to
read
Sorry for the ot.
We put up a new webserver and suddenly having problems with opening pdfs in
the web browser. All the machines have adobe reader or writer. These same
users could open these same pdfs fine on the old webserver.
Is there a setting or something that we're missing on the webserver?
: Janine Jakim [mailto:[EMAIL PROTECTED]]
Sent: 16 December 2002 15:13
To: CF-Talk
Subject: OT: Pdfs not showing on new webserver
Sorry for the ot.
We put up a new webserver and suddenly having problems with
opening pdfs in
the web browser. All the machines have adobe reader or writer
Subject: RE: Pdfs not showing on new webserver
You need to register the mime type.
What webserver?
WG
-Original Message-
From: Janine Jakim [mailto:[EMAIL PROTECTED]]
Sent: 16 December 2002 15:13
To: CF-Talk
Subject: OT: Pdfs not showing on new webserver
Sorry for the ot
I Know this is easyIwant a different background depending on the year
chosen by the user- basically if it ends as an odd number make background
blue if year ends with even number make background green. Is there a better
way than saying cif (Right(#Year#, 1) EQ 1) or (Right(#Year#, 1) EQ 3) or
Thanks- I knew it was super easy
-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 12, 2002 8:38 AM
To: CF-Talk
Subject: RE: Wuick question: if odd/if even
cfif year mod 2 eq 1ODDcfelseEVEN/cfif
-Original Message-
From: Janine Jakim
I'm pulling from a DB4 db and dumping into a SQL db
Most of their numbers from the DB2 are formatted as float.
i remember being told to stay away from float as a datatype.Should I make
the datatype in the sql an integer instead?
Thanks for any insight.
j
The data is generally an id of some sort- teacherid/etc.
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 12, 2002 8:57 AM
To: CF-Talk
Subject: Re: OT-Another quick question- float datatype
Quoting Janine Jakim [EMAIL PROTECTED]:
I'm
-Talk
Subject: RE: OT-Another quick question- float datatype
Quoting Janine Jakim [EMAIL PROTECTED]:
The data is generally an id of some sort- teacherid/etc.
An integer (or at least an exact numeric) should be fine. Frankly, I am
a bit surprised that they used an approximate numeric for an ID
]]
Sent: Thursday, December 12, 2002 8:44 AM
To: CF-Talk
Subject: RE: Wuick question: if odd/if even
yeap, here u go
if (year mod 2)
year even
else
year odd
you can use IIF like this too, but the above is easier to read...
WG
-Original Message-
From: Janine Jakim [mailto
I have a table- that users can add to their classlist.
When adding they can choose multiple students.
I can easily do that loop.
My prob.
Each student will have only one MainTeacher and many peripheral teachers
So before a student is added to a classlist it would need to be checked if
there's
Roll
- Todd Beamer, Flight 93
-Original Message-
From: Janine Jakim [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 9:02 AM
To: CF-Talk
Subject: loop query check??how to do this
I have a table- that users can add to their classlist.
When adding they can choose
http://www.dynamicdrive.com
http://www.milonic.co.uk/menu/
Some very cool stuff at those two sites.
-Original Message-
From: Alford, Sean [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 10, 2002 8:27 AM
To: CF-Talk
Subject: Dynamic Drop Down Menu Bar
Hello Everyone,
I need
I generally make client variables those that aren't going to change while
the user is logged in. (ie:Group type=admin/etc)
I have an app that will have several different forms per student. (some with
one to many relationships/some with one to one).
If a case manager says the forms are complete
hmmm- I am very into keepting my database relational, but am wondering what
the best route for thi particular issue is...
Heres' the scoop
1. One student can be working on many goals so I have 1 one to many
relationships.
2. Each goal needs graded every marking period (up to 6 times a year)-
21, 2002 4:10 PM
To: CF-Talk
Subject: Re: OT: Database design question
Janine Jakim wrote:
1. One student can be working on many goals so I have 1 one to many
relationships.
2. Each goal needs graded every marking period (up to 6 times a
year)- these are not traditioanl grades but a long
Test the page-
comment out the loop/query and put a
cfoutput#ListLen(Form.EmpID_Muster)#--#empID_muster#,
#emp_status#BR/CFOUTPUT
This will show you how it's trying to update the database- and Jim is
probably right that it's trying to do something like
EmpID/Emp_Status
123/1,1,1,1,1,1,1,1,1
-
From: Janine Jakim [mailto:jjakim;albemarle.org]
Sent: Saturday, November 02, 2002 10:41 AM
To: CF-Talk
Subject: RE: Server Error-Urgent
Right but I'm not sure how grouping would work for this. I originally tried
grouping but couldn't get it to output correctly.
The master stored procedure
the outer cfoutput recordcount.
-mk
-Original Message-
From: Janine Jakim [mailto:jjakim;albemarle.org]
Sent: Friday, November 01, 2002 1:22 PM
To: CF-Talk
Subject: RE: Server Error-Urgent
Activepdf is a good product- I agree. But the info it needs to spit out is
pretty large- the stored
Hey has anyone seen this error? It is coming up regularly.
Any ideas where I should start to track down the problem?
Thanks for any insight.
J
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7031
Date: 10/31/2002
Time: 6:00:50
contents
-Original Message-
From: Janine Jakim [mailto:jjakim;albemarle.org]
Sent: 01 November 2002 15:20
To: CF-Talk
Subject: Server Error-Urgent
Hey has anyone seen this error? It is coming up regularly.
Any ideas where I should start to track down the problem?
Thanks for any insight
.
Depending on your CF Admin settings, after x number of these
unresponsive threads, your CF service gets restarted. Check your CF
logs.
Doug
-Original Message-
From: Janine Jakim [mailto:jjakim;albemarle.org]
Sent: Friday, November 01, 2002 10:20 AM
To: CF-Talk
Subject: Server Error-Urgent
Hey
post the code (or the cfoutput/looping part of it).
-mk
-Original Message-
From: Janine Jakim [mailto:jjakim;albemarle.org]
Sent: Friday, November 01, 2002 10:42 AM
To: CF-Talk
Subject: RE: Server Error-Urgent
I have a page that the queries run really quickly but when I set them to
cfoutput
start there. Why don't you
post the code (or the cfoutput/looping part of it).
-mk
-Original Message-
From: Janine Jakim [mailto:jjakim;albemarle.org]
Sent: Friday, November 01, 2002 10:42 AM
To: CF-Talk
Subject: RE: Server Error-Urgent
I have a page that the queries run really quickly
with the data but your best bet is to find the problem in the
HTML/JavaScript and than figure out how that problem got there.
--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 625-9191
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/
-Original Message-
From: Janine Jakim
for that field has an illegal character in it? Or
something to that effect.
--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 625-9191
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/
-Original Message-
From: Janine Jakim [mailto:jjakim;albemarle.org]
Sent: Friday, October
Ok this is odd. I have a 4 section navigation menu. Each section is
dynamically filled in by th database. It works great for 90% of the people.
For the other 10% the menus don't even show up. I have narrowed it down to
one section of the menu and to one query (actually to one field in the
I'm using the basic call to excel (as explained by BF in his book) because I
do know that all my users have excel.
My questions:
1. Can you add an excel toolbar- I want the users to be able to sort the
information on any of the columns.
2. Is there any way to get it so that the headings can
run a test on your query page
do CFPARAM for url.thread
than your CFSET
then CFOUTPUT#Url.thread#/#threadnumber#/cfoutput
see what values come back
j
ps Your url link in your email says it's outputtin formthread. do you mean
thread
-Original Message-
From: Jeremy Bunton
I'm using a script from javascript that opens a new window and populates the
new page. This is great for working with pdfs.
I decided to add it to a page that has a CF_TwoSelectsRelated tag and a
cf_autofill tag. The variables will not pass in the url(makes sense as the
variable isn't defined
the URL's or
generating them dynamically? Either way, make sure your spelling is
correct.
Dave
- Original Message -
From: Janine Jakim [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, September 25, 2002 3:48 PM
Subject: RE: milonic menus question
your right- I actually use
Subject: Re: milonic menus question
I guess I don't understand. How are you populating the attributes.variable?
How about some code.
Dave
- Original Message -
From: Janine Jakim [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, September 26, 2002 8:03 AM
Subject: RE
I've decided that it just doesn't work correctly with milonic menus.
I found an hvmenu from dynamicdrive.com - it worked immediately and is
stable with macs!
Thanks for all the help.
J
-Original Message-
From: Janine Jakim
Sent: Wednesday, September 25, 2002 3:49 PM
To: CF-Talk
Subject
Quick question. I'm having problems passing a variable with the milonic
menus. In my testing I've found that CLIENT variables pass fine- it's my
attributes.variable or form.variable that doesn't pass. Can milonic only
pass client or session variables?
Thanks for any insight.
Janine
]]
Sent: Wednesday, September 25, 2002 12:01 PM
To: CF-Talk
Subject: Re: milonic menus question
I think you're trying to pass URL scope on your variables, not FORM.
Dave
- Original Message -
From: Janine Jakim [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, September 25
Ok I have a link from a menu that doesn't seem to send the one attribute-the
studentID. It sends the urltoken and the teacher id. When I test (ie add
the teacherid to the link name) the studentID shows up ok
so does anyone know why this won't work?
I'm using one of the cool pop up menus from dynamic drive. My topics are
listed on the side of the webpage.
Topic1
Topic2
Topic3
Topic 4
The only thing the users don't like is that when the menu pops up it covers
ALL the other menus. (so if I choose Topic 3 the links under Topic 3 cover
up all
Message-
From: Janine Jakim [mailto:[EMAIL PROTECTED]]
Sent: 19 September 2002 17:55
To: CF-Talk
Subject: Run a check before an insert
Ok I need to make a check on one table before I do an insert into another
table. (Kind of similar to a login where the 1st query checks the
username/2nd query
Usually when I get a message like that in sql it usually means I forgot
something simple like a comma. Are you inserting several things?
-Original Message-
From: Greg Luce [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 20, 2002 1:06 PM
To: CF-Talk
Subject: RE: Access Question
I
Duh- darn loops- just needed one for both queries. Thanks for all the help.
-Original Message-
From: Janine Jakim
Sent: Friday, September 20, 2002 11:10 AM
To: CF-Talk
Subject: RE: Run a check before an insert
Sorry for the delay- been running some traingings.
Here's the real scoop
Ok I need to make a check on one table before I do an insert into another
table. (Kind of similar to a login where the 1st query checks the
username/2nd query checks the group). But I want to be able to have the 1st
table be able to check for several rows in the first query and only insert
the
We have tried lots of fonts etc for the same problem (we use activepdf)
We have found the only solution is to have the person type the information
in Notepad(PC) or Simpletext(Mac). I worked extensively with the support
from Activepdf on this problem and couldn't come up with a solution.
One
Does it work without the trim? Try WHERE email='#i#'
-Original Message-
From: Owens, Howard [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 04, 2002 8:04 PM
To: CF-Talk
Subject: Delete query that doesn't delete (inside a loop)
So, why doesn't this work
cfsetting
Is there a way to anchor how a javascript menu popsup on a mouseover? I'm
using some dynamic menues- they do fine if everything is on the same page
but not well when used with a page with frames. I'd like it so the menu
always shows to the right when there's a mouseover
Thanks in advance,
J
Ok it's definitely Monday.
here's the problem. I have a query outputting for some checkboxes. They
look pretty ugly right now as they all run together. This is the code
TRTD COLSPAN=3CFOUTPUT QUERY=GetCourses
INPUT TYPE=Checkbox NAME=Courses VALUE=#CourseID##CourseName#
/CFOUTPUT/TD /TR
This
did you do a cfparam=monthlyIncome Default=??
-Original Message-
From: mark brinkworth [mailto:[EMAIL PROTECTED]]
Sent: Sunday, August 18, 2002 9:11 PM
To: CF-Talk
Subject: Re: cfinput message on error question
Not sure, but in both cases I got the expected pop up message.
Cheers,
1 - 100 of 283 matches
Mail list logo