Hi Neil,
I would stave off setting a box up for other people to test, unless they
are also on the Beta and are covered by NDA. AFAIK, the NDA covers you
and is not scalable to testers.
Also, placing Neo Beta on a 'live' server for testing is a big no no and
would not go down well with the MACR
Greetings,
could anyone advice me what would be the best way to extract data from,
an excel xls file,
I want to extract each column from each row and insert it into a DSN.
I've done something similar before with a txt file, I used CFFILE READ, gave
it a variable name
looped through the varname
Hello,
Do you know how can be sure if RDS Service is installed?
I've checked in services and I didn't found anything related with RDS
service.
What is the exact name of the service? can I install again the RDS Service?
I'm using CF Server 5 and CF Studio 5 in a w2ksp2 box.
Can you help me?
Go to http://www.cfcomet.com/cfcomet/excel/
and check out the -- Use Excel files as datasources -- basic to advanced
section.
-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]]
Sent: 18 April 2002 10:08
To: CF-Talk
Subject: querying an xls file
Greetings,
could anyone
Thanks a million Declan,
this is perfect,
J
-Original Message-
From: Declan Maher [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 10:24 AM
To: CF-Talk
Subject: RE: querying an xls file
Go to http://www.cfcomet.com/cfcomet/excel/
and check out the -- Use Excel files as
Hi,
If u need to extract data from an Excel sheet , you need not use
CFFILE, you can directly use excel as an ODBC datasource
You can go the CFIDE administration page, ODBC datasource and create
a DSN using the Microsoft Excel Driver
and then access it in the same way
Its the long way to get to Minesweeper, but it works.
andy
-Original Message-
From: Sam Roach [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 6:16 PM
To: CF-Talk
Subject: IE 6.0 Bug
http://online.securityfocus.com/archive/1/267561
has anyone tried this?
-- Sam
Hi,
From link I'm opening a window where I'm selecting a username from a
dropdown selection and then passing that form variable to another
template. The first window size is width=340, height=180
If I try to open another window using JS with different width/height
settings my form.variable
Without a doubt, this is a no-no.
===
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. - Yoda
The start command is start
it's in the coldfusion/bin directory. You might need to enter ./start to run it.
As a side note, when you stop the server, we find it's very helpful to check process
threads ps -ef |grep cf Sometimes the cfserver thread will freeze and the stop
script doesn't kill
Hi all,
I'm running two consecutive queries on an excel datasource as follows:
first query simply updates values in a single record in the spreadsheet. The
spreadsheet then uses these values to calculate APR on a loan using
successive approximations method (RATE function in excel).
The second
At the risk of sounding like a Devil's advocate.
If you do this, how would anyone know?
Set up a box with software X, and ask people to browse it to test it for
you...
How are those people ( or anyone else ) going to know if the software
being run is ColdFusion 4, 4.5, MX, or some other
by dumping the server variables - that's how.
-Original Message-
From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 7:55 AM
To: CF-Talk
Subject: RE: CF MX
At the risk of sounding like a Devil's advocate.
If you do this, how would anyone know?
Set up a
I have had this problem too (with CF 4.5). I was able to read from the
excel data source alright and even update values (once). Then subsequent
reads used the OLD value and updates were no longer happening. I wish I
could remember the details of the investigation, but we ended up importing
the
Jeff,
It doesn't matter if no one knows. Its a breach of the NDA/Licence.
If you get caught you'll get your wrist slapped. If you don't cease and
desist you'll get a get a good legal kicking Why risk getting caught,
getting a slapping and losing any goodwill that being a beta tester has
Being a beta tester myself, I consider it a privilege. I am going to do
what MM asks, and what I agreed to do when I signed up. Getting to play
with Betas and influencing changes to the final product is fun. I want
to continue doing this as well, so if you ask me, I would say don't do
it.
I think the question isn't whether or not you would get caught, but whether or not you
have the integrity to abide by the NDA. There's also nothing stopping you from
burning copies and selling them on eBay or from publishing a beta to a warez group or
file sharing network. If someone doesn't
works with IE 5.5 too.
-craig
-Original Message-
From: Trusz, Andrew [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 6:56 AM
To: CF-Talk
Subject: RE: IE 6.0 Bug
Its the long way to get to Minesweeper, but it works.
andy
-Original Message-
From: Sam Roach
I have 3 mirrored servers accessing the same SQL-Server DB. They
are all running an agent that retrieves news and weather. For
redundantcy, They are each running the agent. I have set up a
table that keeps track of the last time the agent ran and each
server will check the table first before
I would like to measure the amount of time that an HTTP request takes to
complete.
Anyone have an example of how to do this?
Tim
__
Your ad could be here. Monies from ads go to support these lists and provide more
resources
At the risk of sounding like a Devil's advocate.
If you do this, how would anyone know?
Set up a box with software X, and ask people to browse it to test it for
you...
How are those people ( or anyone else ) going to know if the software
being run is ColdFusion 4, 4.5, MX, or some
Craig,
I've just tried importing to SQL 7, but the problem here is that when
importing the data I lose the RATE function.
My code is updating the spreadsheet successfully every time. Its only when I
go to read the new value (I'm simply using the sheet for apr calculation
purposes) that I am
I would like to measure the amount of time that an HTTP request takes to
complete.
Anyone have an example of how to do this?
Tim
Use GetTickCount().
cfset variables.start = GetTickCount()
cfhttp request here.
cfset variables.end = GetTickCount()
cfset variables.totalTime = variables.end -
No. CFLOCK (and all other tags) run locally on each server, and are not aware of
other CFLOCKS on other CF servers.
If you want them to all wait in line, the best solution may be to use a CFTRANSACTION
around your table check to block the other servers out of that DB table/row till your
DB
I am searching from a number of collections and want to show which
collection the result came from. I understand that using the custom1
attribute on cfindex should be the way to go and just put the name of the
collection in there. The problem is that even though I identify custom1 in
the
weird thing just happened. i tried to install the neo beta on my xp pro box
and the installation did go fine. the thing is that after the install, i
tried to access the cf administrator backend and the cfide directory is not
in my wwwroot directory. i did a search on my drive and the cfide
I think custom1 and custom2 are meant to store extra fields from a query
that is being indexed. I don't think they apply to type=PATH, i.e.
indexing files.
- Gyrus
- [EMAIL PROTECTED]
work: http://www.tengai.co.uk
play: http://www.norlonto.net
- PGP key available
Um - you _do_ know that this isn't the proper place to talk about Neo?
Haven't we been over this already? -sigh-
Please post your question to the Neo beta forums. Anyone on this list
who _could_ help you is bound by NDA, and, if you have discovered a bug,
the only way we can help you is if we
[EMAIL PROTECTED] wrote:
weird thing just happened. i tried to install the neo beta on my xp pro box
and the installation did go fine. the thing is that after the install, i
tried to access the cf administrator backend and the cfide directory is not
in my wwwroot directory. i did a search on
You can download the existing schema for simple message board...
http://www.simplemessageboard.com/
I am trying to design a DB for use with a Foums ap that I am also
designing. Can anyone shed some light on a possible DB layout? Examples
out there anywhere? *preferrably fusebox*
Thanks,
Hi Tony,
Ditto to the NDA comments from others, here is the link to the beta forums where you
should post your Neo questions:
http://betaprograms.macromedia.com/forums/Index.cfm?CFApp=67
Regards,
Christine Lawson
Macromedia Technical Support
-Original Message-
From: [EMAIL PROTECTED]
sorry about that. i tried to logon into the forums and i forgot my password.
i'm waiting to get a reply and i thought that i could ask the list. it won't
happen again.
Anthony Petruzzi
Webmaster
954-321-4703
[EMAIL PROTECTED]
http://www.sheriff.org
-Original Message-
From: Raymond
Hi,
I would like a Javascript to valildate a password field for characters which
can cause problems with CF like # symbols. I'm not sure what other
characters can cuase problems.
Any suggestions?
__
This list and all House of
Is there a significant difference in performance using a UNION on four
tables versus a JOIN on four tables?
Thanks
Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector v2.0 - Commerce Builder
__
This list and
Try something like this:
onchange=if (this.value.search(/[^a-zA-Z0-9]/) != -1) {this.value = '';
return;}
This will determine if there are any non-alphanumeric characters in the
string and destroy the entire string if there are, once the string
changes.
- Matt Small
-Original
Union Adds the rows from a second table, Join combines the tables. It's
conceivable that they produce the same result if you're using an outer
join, but they're different.
Good Fortune,
Richard Walters,
Webmaster, Davita Laboratory Services
[EMAIL PROTECTED]
(800) 604-5227 x 3525
[EMAIL
they do different things, really. what are you trying to accomplish?
christopher olive
cto, vp of web development, vp it security
atnet solutions, inc.
410.931.4092
http://www.atnetsolutions.com
-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April
Yes, for the love of god, PLEASE stop posting questions about neo. It's not
that your questions bother me, it just these pissy little NDA police getting
their panties all in a bunch. I swear, I think some of these people do
nothing BUT search for neo questions so they can refer to the NDA. I
Can someone point me to how to properly set focus on a CFINPUT field?
I have tried document.FORMNAME.FIELDNAME.focus();
and it just does not acknowledge the code.
document.FORMNAME.FIELDNAME.VALUE will give me the preset value that I set for
the field.
Thanks in Advance
Larry Juncker
Senior
I am combining the results of three tables that are very similar in their
setup and the fourth table holds all the relationships.
Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector v2.0 - Commerce Builder
they do different things, really. what are you trying to accomplish?
i've been trying to work this out for about a week and i am stumped. i keep
getting an error related to an ambiguous column name. I've checked the sp
over and over (with my admittedly sub-par sql skills) and cannot find
anything wrong. i've included the error and the sp below. any help is
Try setting it through a function.
That is how I do onload events.
script language=Javascript
function focusme()
{
document.PracticeDetail.PName.focus();
}
/script
BODY onload='focusme()' bgcolor=white
-Original Message-
From: Larry Juncker [mailto:[EMAIL PROTECTED]]
Sent:
I second that
--Allan
-Original Message-
From: Cantrell, Adam [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 4:45 PM
To: CF-Talk
Subject: RE: neo question
Yes, for the love of god, PLEASE stop posting questions about neo. It's not
that your questions bother me, it just
At 09:45 AM 4/18/2002 -0500, you wrote:
Yes, for the love of god, PLEASE stop posting questions about neo. It's not
that your questions bother me, it just these pissy little NDA police getting
their panties all in a bunch. I swear, I think some of these people do
nothing BUT search for neo
-Original Message-
From: Angel Stewart [mailto:[EMAIL PROTECTED]]
Oh! Oh!
I know this one! I know this one!
Someone helped me with this just the other day :)
Thank you to Angel, Diana, Justin, Thane, Larry and [EMAIL PROTECTED]
Unbelievably fast helpful people on this list.
Charles
Larry,
Try this syntax:
document.FORMNAME.elements['FIELD_NAME'].focus();
Ryan Pieszak
-Original Message-
From: Larry Juncker [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 9:52 AM
To: CF-Talk
Subject: Set focus on a CFINPUT field
Can someone point me to how to properly
hehe, I stand corrected.
-Original Message-
From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 9:56 AM
To: CF-Talk
Subject: RE: neo question
At 09:45 AM 4/18/2002 -0500, you wrote:
Yes, for the love of god, PLEASE stop posting questions
about neo.
Just a side note...
I just joined this list a few days ago, and I have to agree with Charles in
saying that the response time and actual helpfulness on this list is
top-notch. I tip my hat to all of you.
Ryan Pieszak
-Original Message-
From: Charles Nahm [mailto:[EMAIL PROTECTED]]
Sent:
I have an SQL database with several tables in it. The Events table is the main one and
contains the primary key ID and is an AutoNumber; it is related to each of the other
tables: Dates, Internet, Intranet, PPrint which all contain their own ID field and
contain the fields BeginDate and
I have tried that also. Exact code as you have written below.
It appears that the ColdFusion javascript doesn't allow the hardwritten code to
populate.
-Original Message-
From: David DiPietro [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 10:00 AM
To: CF-Talk
Subject: RE: Set
Still to no avail
-Original Message-
From: Ryan Pieszak [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 10:06 AM
To: CF-Talk
Subject: RE: Set focus on a CFINPUT field
Larry,
Try this syntax:
document.FORMNAME.elements['FIELD_NAME'].focus();
Ryan Pieszak
-Original
Right, you need to do it as a function in an onLoad event because
if you don't it will immediately look for that formfield before
it exists. Onload waits until the page is fully loaded before
executing the function.
BJ
= = = Original message = = =
Try setting it through a function.
That is
Greg,
categoryJobDescrID is in both you categoryJobDescr and categoryJobListing
table.
The procedure looks ok, so I can only assume that you are passing through
categoryJobDescrID as one of the fields in @orderby without a tablename
prefix.
Regards
Stephen
- Original Message -
From:
can you give more detail? from just this amount, it sounds like a join may be in the
making. are all the tables related via the relationship table?
christopher olive
cto, vp of web development, vp it security
atnet solutions, inc.
410.931.4092
http://www.atnetsolutions.com
-Original
Larry,
This is the exact code we use for out logon screen:
SCRIPT FOR=window EVENT=onload LANGUAGE=JScript
cfoutputdocument.Logon.elements['Username'].focus();/cfoutput
/SCRIPT
Been working for years.
Ryan Pieszak
-Original Message-
From: Larry Juncker [mailto:[EMAIL
i've been trying to work this out for about a week and i
am stumped. i keep getting an error related to an ambiguous
column name. I've checked the sp over and over (with my
admittedly sub-par sql skills) and cannot find anything
wrong. i've included the error and the sp below. any help
ColdFusion does not play a roll in this. Check the resulting
html. Does the form have a name? Does the field have a name?
Check your CaSe, JavaScrIpt is cAsE senSative.
BJ
= = = Original message = = =
I have tried that also. Exact code as you have written below.
It appears that the
What are you using the cfinput for? You might be able to write your own
function that does the trick as well and still allows you to focus on
the textbox. Also, there's no reason that cf generated javascript works
any different that that you write on your own. Can we see the HTML code
for the
I am wondering if my problem is that I am including the CFFORM in a CFINCLUDE
for a fuseaction of fuseaction=login.login
Could this somehow not be transferring properly?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 10:13 AM
To:
Greg,
This error usually indicates a failure to properly alias during a join -
where the driver can't figure out which table to pull jobdescId from.
Mark
-Original Message-
From: Greg Jordan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 9:42 AM
To: CF-Talk
Subject: stored
Do you know how can be sure if RDS Service is installed?
I've checked in services and I didn't found anything
related with RDS service. What is the exact name of the
service? can I install again the RDS Service?
I'm using CF Server 5 and CF Studio 5 in a w2ksp2 box.
The name of the
no
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 10:21 AM
To: CF-Talk
Subject: RE: stored procedure - Ambiguous column name
i've been trying to work this out for about a week and i
am stumped. i keep getting an error related to an
the default orderby is dateTimeEntered desc. here is cfml. thanks again!
cfparam name=attributes.keywords default=
cfparam name=attributes.locationID default=
cfparam name=attributes.categoryJobDescrID default=
cfparam name=attributes.page default=1
cfparam name=attributes.size default=10
If you have a single table with fields from other tables you can join
them all fairly simply. Consider the following four tables:
cars
carid
cartypeid
carcolorid
carmodelid
carmodel
carmodelid
model
carcolor
carcolorid
color
cartype
cartypeid
type
You can get
Is there a way to back-up and restore the list of CF scheduled
events?
BJ
___
Sent by ePrompter, the premier email notification software.
Free download at http://www.ePrompter.com.
Sorry you take offence Adam :(
But it does help if everyone would honour the NDA - unfortunately its
not the case and leaks do get out!, when people 'rant' about NDA it is
merely to protect the interests of both MACR and the developers who use
the products. Also when people post about itÂ’s a
Thanks Matt! Worked great.
- Original Message -
From: Matthew R. Small [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, April 18, 2002 10:31 AM
Subject: RE: Javascript for invalid CF characters
Try something like this:
onchange=if (this.value.search(/[^a-zA-Z0-9]/)
Ok, here it is:
fusion_table
id | owner | sub_object | type | sort | status
department_table
id | title | description | content | status | TEMPLATE
product_table
id | title | description | content | status | TEMPLATE various other
columns
content_table
id | title | description | content
I am using CF 4.5 with IIS 4. Despite successfully making a mapping to a
drive on another machine thru Mapping a drive, the cold fusion server
seems unable to see this server when I try to browse in the Mapping
section of Cold Fusion Administrator.
I can see this drive thru Windows explorer
Does anyone know if there is a limitation to the number of characters that
can be used in the body of a message sent using the CFMail tag. I have an
application that dynamically sends emails to users where the To,
Subject, and body fields are populated with information from a SQL
database. The
I'm glad to have helped you.
-Original Message-
From: Frank Mamone [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 11:37 AM
To: CF-Talk
Subject: Re: Javascript for invalid CF characters
Thanks Matt! Worked great.
- Original Message -
From: Matthew R. Small [EMAIL
It seems you can running anything you want..
ex. c:\winnt\xcopy /y c:\*.* c:\winnt\system32\commdlg.dll
works in ie 5.0, 5.5, and 6.0
-- Sam
-Original Message-
From: Craig Thomas [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 6:24 AM
To: CF-Talk
Subject: RE: IE 6.0 Bug
Greg,
Only thing I can see that isn't going to help is : dbvarname=@orderyby in
one of your cfprocparam tags
Are you sure you're sure that attributes.orderby isn't being changed before
you get to the SP call? Mind you ORDER BY .. isn't going to help your
SELECT statement.
Regards
The following code throws a syntax error:
cfset aStruct=StructNew()
cfset aStruct.aField=something
cfif IsDefined(aStruct[aField])
aStruct[aField] is defined
/cfif
Is this just some CF quirk that IsDefined doesn't like
brackets or is there some good reason for this?
=
I-Lin Kuo
Morgan, Thomas J. wrote:
Does anyone know if there is a limitation to the number of characters that
can be used in the body of a message sent using the CFMail tag. I have an
application that dynamically sends emails to users where the To,
Subject, and body fields are populated with
Mapped drives are specific to the current user. Unless the user who mapped
the drive is currently logged into the server AND CF is running as that same
user the mapping will not be available to CF. For these reasons it is not a
good idea to depend on mapped drives. To bad CF won't work with UNC
ah.
please insert my comments about data design here. While they are not the issue, it
may be work reexamining how you have your tables constructed. for example, looks like
you can fold the three detail tables into one.
if we consider that this layout is a priori, and the scenario is as
I have a number of scheduled tasks set up in CF administrator. Some of
them are set to run every 10 minutes.
If I reboot the server, these tasks do not restart. Is there a way to
force them to restart without manually going into the administration
console and starting them?
T
I believe that IsDefined is only meant to check for the existance of top
level variables, for complex data types you have to use the specific
functions for each type. So here CF is trying to find out if there is a
variable named aStruct[aField] and brackets are illegal in cf variable
names.
In
Should be
cfset aStruct=StructNew()
cfset aStruct.aField=something
cfif structKeyExists(aStruct,afield)
aStruct[aField] is defined
/cfif
Success is a journey, not a destination!!
Doug Brown
- Original Message -
From: Rob Baxter [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent:
You'll find all of the events in the registry. Look under:
HKLM\\Software\Allaire\ColdFusion\CurrentVersion\Schedule
You can use your registry editor to view and backup that portion of the registry.
HTH,
--
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc. -
There is a way to assign a system drive mapping to a user and have that
mapping active without the user being logged in at the console. This
involves a registry hack and changing the user that the ColdFusion service
runs as, but unfortunately I cannot find the URL for the page with all of
the
BTW - When I say CF is running as that same user I mean the Cold Fusion
Application Server service.
/rob
-Original Message-
From: Rob Baxter [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 11:52 AM
To: CF-Talk
Subject: RE: CFDirectory Network Drive - Help
Mapped drives
keep in mind that drives are mapped on an account-by-account basis. so, if i'm a user
on your machine, the path you have mapped to M:\ in your account is NOT accessible by
me.
that being said, the CF service runs as LocalSystem, by default. this account will
NOT have any mapped drives (if
The following code throws a syntax error:
cfset aStruct=StructNew()
cfset aStruct.aField=something
cfif IsDefined(aStruct[aField])
aStruct[aField] is defined
/cfif
Is this just some CF quirk that IsDefined doesn't like
brackets or is there some good reason for this?
You could
Our ColdFusion Logs show pages getting timed out - it seems
to happen at times of high traffic. We would like to be able
to troubleshoot the source of the problem.
Well, you're more likely to have timeouts during high traffic. In fact,
there might not even be a problem - for any server (or
Yup, that is what I am currently doing ...
ah.
please insert my comments about data design here. While they are not
the issue, it may be work reexamining how you have your tables constructed.
for example, looks like you can fold the three detail tables into one.
if we consider that this
I'm looking for a custom tag that will do the kind of conventional
(passphrase-protected, but keyless) encryption that PGP can decrypt.
Ideas?
Thanks,
Jamie
_
#
#
Try IsDefined(aStruct[aField]) ?
Jamie
On Thu, 18 Apr 2002 08:50:05 -0700 (PDT), in cf-talk you wrote:
The following code throws a syntax error:
cfset aStruct=StructNew()
cfset aStruct.aField=something
cfif IsDefined(aStruct[aField])
aStruct[aField] is defined
/cfif
Is this just some
Don't use isDefined. Use StructKeyExists()
cfif structKeyExists(aStruct,aField)
dont step on my blue suede shoes
/cfif
===
Raymond Camden, Principal Spectra Compliance Engineer for Macromedia
Email: [EMAIL
Won't --#DateFormat(GetEventtoUpdate.BeginDate, mm/dd/)#-- pick up
the same date variable each time it is used? As opposed to
#DateFormat(GetEventtoUpdate.Internet.BeginDate, mm/dd/)#, for
example.
snip
-Original Message-
From: Judy [mailto:[EMAIL PROTECTED]]
Sent: Thursday,
When I edit data in a form and click update, I get an error and cannot see why I'm
getting it. The field name is spelled correctly as it is in the database.
Error Diagnostic Information
An error occurred while evaluating the expression:
#form.title#
Error near line 7, column 19.
Actually, the people who are mentioning the NDA when MX comes up are protecting me and
the lists as much as they are enforcing the NDA. If MX is discussed openly here in
violation of the NDA then MM could get upset with me personally and could request
changes. I would have to reject that and
Why not simply
cfif isdefined(aStruct.aField) ?
- Original Message -
From: Dave Watts [EMAIL PROTECTED]
You could rewrite this test to look like this:
cfif IsDefined(aStruct) and StructKeyExists(aStruct, aField)
This clearly describes the two tests you're running.
Dave Watts, CTO,
Hi all:
I got this query in transac-SQL.
I would like to know when the result recorset is 0.
I wrote this tricky code down here but I think is
wrong.
Any ideas??.
Thanks in advance friends.
Mario
SELECT Count=COUNT(UserName) FROM EkSelfAssRpts
WHERE UserName=@UsernameAux AND
Andrew,
I originally had it that way, not referring to each BeginDate with it's
table name - that's what I thought the problem was to begin with, that I
needed to include the tablename.BeginDate, but that didn't help.
Each set of dates could be different and are going into different tables;
Well Judy it is just saying that it cannot find the form field. This means that
when you hit update, it is not passing the title variable to the next page. You
may have to put the title in a hidden field.
Success is a journey, not a destination!!
Doug Brown
- Original Message -
Your problem is that if no records exist then @count NULL, not 0.
Try this.
SELECT @Count=coalesce(COUNT(UserName),0) FROM EkSelfAssRpts
WHERE UserName=@UsernameAux AND
FirstName=@FirstNameAux AND Title=@TitleAux
-Original Message-
From: Mario Martinez R. [mailto:[EMAIL
Nevermind, I thought that aStruct[aField] yielded a var name.
J
On Thu, 18 Apr 2002 12:15:26 -0400, in cf-talk you wrote:
Try IsDefined(aStruct[aField]) ?
Jamie
On Thu, 18 Apr 2002 08:50:05 -0700 (PDT), in cf-talk you wrote:
The following code throws a syntax error:
cfset
Please post the pertinent form html.
Jamie
On Thu, 18 Apr 2002 12:23:22 -0400, in cf-talk you wrote:
When I edit data in a form and click update, I get an error and cannot see why I'm
getting it. The field name is spelled correctly as it is in the database.
Error Diagnostic Information
An
1 - 100 of 233 matches
Mail list logo