Thanks Bud: Re: SQL Server database restore

2001-04-10 Thread sebastian palmigiani
on 4/10/01 1:54 PM, Bud at [EMAIL PROTECTED] wrote: It's pretty easy. Right click on the databases directory in EM, go under the All Tasks menu and choose Restore Database. Hey Bud. Thanks. I knew there was an easy way to do this. Also thank you Adrian Cooper and Adrian Cesana for the

Studio 4.5.2

2001-04-11 Thread sebastian palmigiani
I upgraded to CF Studio 4.5.2 with Win98. It kept repeatedly crashing my system. I had to go back to Studio 4.0. Is this just an issue with Win98 or would it be the same story with Win2000? I am disspointed in this 'improvement.' Sebastian ~~

Re: Studio 4.5.2

2001-04-11 Thread sebastian palmigiani
was working with before. Hope this helps Sandy Clark Shayna Productions http://www.shayna.com -Original Message- From: sebastian palmigiani [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 11, 2001 10:00 AM To: CF-Talk Subject: Studio 4.5.2 I upgraded to CF Studio 4.5.2

Re: Link to download .jpg or gif

2001-04-12 Thread sebastian palmigiani
How about just putting a link text 'Right click to download' under the thumbnail. It's not ideal but it works. Sebastian on 4/11/01 10:17 PM, scottw at [EMAIL PROTECTED] wrote: I am looking for a solution to a downloading problem i am having with a link. I am thumbnailing images, and am

Re: Picture Size

2001-04-12 Thread sebastian palmigiani
on 4/12/01 1:20 PM, William J Wheatley at [EMAIL PROTECTED] wrote: Has anyone come up with a way to check the size of a picture being uploaded before it actually gets uploaded? Instead of having to do it on the server side afterwards? Try: cfif CGI.CONTENT_LENGTH GT /cfif Sebastian

Security Scripting

2001-04-13 Thread sebastian palmigiani
There is an excellent small article on security vis a vis URL, cookie and form parameters at: http://webreview.com/2001/04_13/developers/index02.shtml My question is what do the members of this list use to prevent malicious attempts to alter or destroy a database by means of the URL form or

Re: Security Scripting

2001-04-13 Thread sebastian palmigiani
=12345+TRUNCATE+TABLE+Items cfquery name="foo" datasource="bar" Select * from Users where UserID = #Val(url.UserID)# /cfquery - Original Message ----- From: "sebastian palmigiani" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, A

http 500 Internal Server Error and CF installation

2001-04-18 Thread sebastian palmigiani
I have just installed CFServer 4.5.1 on Windows 2000 with IIS. I get the html pages to display but not the cfm pages, when for example, going to the cf administrator page. I get an http 500 Internal Server Error. I have followed all the instructions in the knowledge base article 7671 and the

Re: http 500 Internal Server Error and CF installation

2001-04-18 Thread sebastian palmigiani
with MDAC 2.5, and when installing CF over it, it breaks. just "upgrade" to Win2K FROM win2K and it'll be fine. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message----- From: sebastian palmigiani [mailto:[EMAIL PROTECT

locks and StructClear

2001-04-19 Thread sebastian palmigiani
What type of lock is used with StructClear(Session)? Is it ReadOnly or Exclusive? Sebastian ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives:

OT:CyberCash

2001-04-20 Thread sebastian palmigiani
I am thinking of using CyberCash. How is their performance and service since they have declared bankruptcy? Sebastian ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm

cfcache with database changes

2001-04-21 Thread sebastian palmigiani
Am I missing something or is this the way that the cfcache tag is supposed to work? I have a page which has a menu that derives its data from the database. So I use the cfcache tag on that page set to action="CACHE" I use the following only after a change that affects the menu is made to the

validating URLs with regex

2001-04-26 Thread sebastian palmigiani
REFind('^http://[\./-:0-9a-zA-Z]+$', URL) I want to be able to validate the url. This works REFind('^http://[\./-:0-9a-zA-Z]+$', URL) But I want to allow - _ ? = and alphanumeric characters in the query string but not in the first part of the URL. What do I need to add to

ValueList() in CF 4.5

2001-05-02 Thread sebastian palmigiani
The ValueList function in CF 4.5.1 inserts a space between values using the default delimiter. The table column has the following values: '3.1' and '3.2' When I do a query and use the ValueList function RoleID = ValueList(Query.Column) it outputs as 3.1 ,3.2 with an extra space. As a

Mid function for lists

2001-05-07 Thread sebastian palmigiani
Is there a way of extracting groups of elements within a list like using the Mid function for extracting groups of chracters within a string? I want to loop through the list to extract groups of emails and put each group in BCC in cfmail as a way of circumventing the limitation of the cfmail

CFMAILPARAM and X-Mailer

2001-05-07 Thread sebastian palmigiani
Can you use the CFMAILPARAM tag to reset the value of the X-Mailer header in cfmail so you can bypass ISPs who consider X-Mailer: Allaire Cold Fusion as spam mail? Thanks, Sebastian ~~ Structure your ColdFusion code with Fusebox. Get the

bcc and lists

2001-05-08 Thread sebastian palmigiani
How do I retrieve sets from a list so as to loop through the list and send groups of emails in the bcc field rather than the whole list at once or only one at a time? cfset MailList = ValueList(GetEMails.EMail) cfmail to='[EMAIL PROTECTED]' from='[EMAIL PROTECTED]' subject='newsletter'

Re: Q. about Encoding

2001-05-09 Thread sebastian palmigiani
on 5/9/01 6:01 AM, Michael Lugassy at [EMAIL PROTECTED] wrote: Is it possible to Encode a certain string into specific set of characters? when I use the Encode() function it gives out a WELL ENCODED STRING, but the problem is that it's TOO ENCODED - It can't seem to be placed securely into

Re: How do I open an IE window into fullscreen channel mode?

2001-05-09 Thread sebastian palmigiani
Hi Spadea. Welcome to the list. Try this in the head section. SCRIPT LANGUAGE=JavaScript !-- BrowserName = navigator.appName; BrowserVersion = parseInt(navigator.appVersion); if (BrowserName == Netscape) { self.moveTo(0,0) self.resizeTo((screen.availWidth-8),(screen.availHeight-45)) } else {

default spool file

2001-05-09 Thread sebastian palmigiani
I had a problem with cfmail where it kept sending the same email over and over again. I had to stop the CF service. I checked the spool directory and found the following spool file: c:\CFusion\Mail\Spool\2A.CFMAIL=1 That was the name of the email that was beeing sent over and over. What is the

Counting members online.

2001-05-12 Thread sebastian palmigiani
Counting members online. I am developing a member site with log on. How can one accurately count how many members are online at a particular time. My idea is to set up an application variable counter which increases when a person logs on and decreases when a person logs out. How can I account

Forced logout

2001-05-13 Thread sebastian palmigiani
How can I use javascript to make a member logout if they go to a different web site? Is this possible to do with javascript. Sebastian ~~ Structure your ColdFusion code with Fusebox. Get the official book at

Re: grab links from a webpage

2001-05-15 Thread sebastian palmigiani
on 5/15/01 10:57 AM, Art Broussard at [EMAIL PROTECTED] wrote: I can pull up the page using cfhttp. Now how do I search for links on it? Do i need to use find or refind? I don't fully understand reg expressions so I don't know how to use it that well.go To learn more about regular

Re: E-commerce Dilemma

2001-05-15 Thread sebastian palmigiani
on 5/15/01 5:19 PM, Alexandre Dornback at [EMAIL PROTECTED] wrote: Check this out. It kills both of the carts you are looking at! I personally know the guy who wrote this and it is simply the best app you can find for a core commerce engine. Here is a feature list.. You forgot the URL.

cfcatch and email

2001-05-21 Thread sebastian palmigiani
I want to send an email with database error info using cftry/cfcatch. But it is not working. Am I trying to do something that can't be done within a cfcatch block? Sebastian --- cftry cfquery name='foo' datasource='foo' Select * from members /cfquery

Re: cfcatch and email

2001-05-22 Thread sebastian palmigiani
populate a variable with the email message and then outside the try block check to see if the message is not empty and then send an email if so? Bryan - Original Message - From: sebastian palmigiani [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 21, 2001 10:39 PM

Re: Compromising Security

2001-05-22 Thread sebastian palmigiani
Is this the most efficient way to check for SQL in form input? Sebastian -- cfset FORM.FirstName = 'Sebastian' cfset FORM.LastName = 'Palmigiani' cfset FORM.Address = ';drop table members;' cfset FormList = '' cfset FormList = ListAppend(FormList, FORM.FirstName) cfset

Re: basic question

2001-05-23 Thread sebastian palmigiani
Yes they do. I call an encrypted tag like cf_counter which does not need any attributes and what gets outputted is the encryption. Sebastian on 5/23/01 4:04 AM, Thomas Chiverton at [EMAIL PROTECTED] wrote: I downloaded an encrypted custom tag. When I make a call to the tag it shows up all

more locking questions

2001-05-24 Thread sebastian palmigiani
1. In a shared hosting environment if you do proper locking of session variables in your application and another application does not how does that affect you? 2. If the answer to number 1 is that it destabalizes your application would it then be better to have variables stored in cookies

request scope confusion

2001-05-29 Thread sebastian palmigiani
I am trying to understand the request scope. What is the difference between putting cfset DSN = 'foo' vs. cfset request.DSN = 'foo' in the application.cfm template or in any template? Thanks, Sebastian ~~ Structure your ColdFusion code with

Re: case

2001-05-29 Thread sebastian palmigiani
LCase(yourword) on 5/29/01 4:36 PM, Jones, Becky at [EMAIL PROTECTED] wrote: is there a cf command that would allow me to force a word to output in all lowercase? thanks, bec. * This e-mail, including any attachments, is intended for

Re: Email

2001-05-29 Thread sebastian palmigiani
on 5/29/01 10:44 PM, Parker, Kevin at [EMAIL PROTECTED] wrote: Can I create a search interface to the contents of a mail box without moving the contents to a dB. You can use Verity to make a collection of the messages, index them and do a cfsearch on them. Sebastian

highlighting search terms

2001-05-31 Thread sebastian palmigiani
I want to develop a highlight function of search terms. The following works well except that it changes the case of the keyword in the output. For example, 'Cold' in the original becomes 'cold' in the output. What can I include in the code to keep the original case of the String? If I use

can anyone help?

2001-05-31 Thread sebastian palmigiani
I have win2K professional with personal web server for development. PWS is hanging after any requests, whether with an htm or cfm file request. When choosing any options in PWS I get the following message: Server is busy This action cannot be completed because the other program is busy. Choose

Re: can anyone help?

2001-05-31 Thread sebastian palmigiani
OK. I have ditched PWS. I have installed Apache and reinstalled ColdFusion and copied the DLL file and changed the httpd.conf file in apache. I cannot get the web server to start. When I click on start apache I get a dos command window that goes so fast I can't even read what it says. I was

Re: can anyone help?

2001-05-31 Thread sebastian palmigiani
on 5/31/01 9:40 AM, Arden Weiss at [EMAIL PROTECTED] wrote: See Apache installation instructions paper ColdFusion and Apache install tips and tricks by Mark Mathis on Annapolis Cold Fusion Users Group web site (2/22/01 meeting) if you decide to go that route. It will help...

Apache web server

2001-05-31 Thread sebastian palmigiani
I have installed the Apache web server and when I get this page to test the installation http://127.0.0.1/CFDOCS/testinstallation/test.cfm When I click on Verify query I get: The requested method POST is not allowed for the URL /CFDOCS/testinstallation/courses.cfm. Also, I can't get the Cold

Re: can anyone help?

2001-05-31 Thread sebastian palmigiani
Thanks for all your help. I have got Apache working with ColdFusion. Sebastian on 5/31/01 4:39 PM, Dave Watts at [EMAIL PROTECTED] wrote: OK. I have ditched PWS. I have installed Apache and reinstalled ColdFusion and copied the DLL file and changed the httpd.conf file in apache. I

Apache and trailing back slash

2001-06-01 Thread sebastian palmigiani
I do not understand why you get trailing back slash when using GetDirectoryFromPath with Apache web server cfoutput#GetDirectoryFromPath(CGI.CF_TEMPLATE_Path)#/cfoutput In other words I get c:/program files/apache group/apache/htdocs/members/om/archive/adu/\ Why is there a trailing back

Re: Help sought with CFX_DIRECTORYLIST

2001-06-06 Thread sebastian palmigiani
on 6/5/01 2:35 PM, Mike Brunt at [EMAIL PROTECTED] wrote: Larry, it is almost always a good idea to lock CFX tags using CFLOCK. The threading info could relate to memory threading issues. I have a good article on using cflock, if you would like a copy please let me know. What type of lock

fusebox and cfschedule

2000-10-23 Thread sebastian palmigiani
Where would one put scheduled events that are to run automatically using the fusebox method? In the index.cfm with cfswitch is not the appropriate place. Sebastian Archives:

Re: CF 5.0 Bug Vote is Now Open!

2000-10-25 Thread sebastian palmigiani
on 10/26/00 2:53 AM, Benjamin S. Rogers at [EMAIL PROTECTED] wrote: How many times have you referenced a Session variable or called CFFILE without using CFLOCK? Using cflock with cffile is new to me. What is the reason for that? Sebastian

Re: Datatype Mismatch in Access

2000-10-29 Thread sebastian palmigiani
on 10/29/00 7:42 PM, Harry Kurrosawa at [EMAIL PROTECTED] wrote: cfquery name="AddAccount" datasource="netinfhosts" debug="Yes" Insert into CompanyInfo (HostName, RoleContact, ContactName) Values('Host Test', 'Yes', 'Sales Manager')/cfquery Try the number 1 instead of 'Yes'

I have never done this.

2000-11-05 Thread sebastian palmigiani
What are the general steps for querying an excel spreadsheet? I would think that you would first use cfhttp to get the file. Would you use a comma as the delimiter and "" as text qualifier? Sebastian

fusebox problem

2000-11-16 Thread sebastian palmigiani
I understand that each directory is to have its own index.cfm page which acts as a switchboard for that directory. What I don't understand is how to access them from the main home page and have the main home page display the different actions from each sub directory. Example of what I have.

Re: SQL 7.0

2000-11-16 Thread sebastian palmigiani
on 11/16/00 4:01 PM, ibtoad at [EMAIL PROTECTED] wrote: Ok I am now very comfortable with MS Access and am ready to learn MS SQL 7.0. Can anyone recommend a book? I would recommend "Beginning Visual Basic SQL Server 7.0." Although it focuses on using Visual Basic with SQL Server it has an

Checking for Field Name Existence

2000-11-25 Thread sebastian palmigiani
I have an uploaded file which is turned into a query set. I want to be able to check that the uploaded file has the field name in it. ---uploaded file: directory.txt "custno" "GALC1" "APER1" "AALB1" "SPAL1" -retrieve file cfhttp method="get"

Column Names

2000-11-27 Thread sebastian palmigiani
I have an uploaded file which is turned into a query set. I want to be able to check that the uploaded file has the field name in it. ---uploaded file: directory.txt "custno" "GALC1" "APER1" "AALB1" "SPAL1" -retrieve file cfhttp method="get"

Re: cfstored procedure problem

2000-12-06 Thread sebastian palmigiani
on 12/5/00 3:46 PM, S R at [EMAIL PROTECTED] wrote: Hi everyone, I can't figure this one out. I'm using SQL Server 7.0 and CF 4.5 This is my stored procedure in SQL: @SAMAccountName varchar AS SELECT UserID FROM PasUsers WHERE SAMAccountName = '@SAMAccountName' I don't know if

CF_SQL_DATE

2000-12-07 Thread sebastian palmigiani
I am using CF 4.0 with MS SQL Server 7.0 Is there an issue with using cfsqltype="CF_SQL_DATE" in a stored procedure? I get the following error code while using a stored procedure -- ODBC Error Code = S1C00 (Driver not capable)

Re: CF_SQL_DATE

2000-12-07 Thread sebastian palmigiani
="#createODBCDate(createDate( month,day and year from startdate))#"? -Original Message----- From: sebastian palmigiani [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 07, 2000 10:52 AM To: CF-Talk Subject: "CF_SQL_DATE" I am using CF 4.0 with MS SQL Server 7.0

cfmail

2000-12-19 Thread sebastian palmigiani
cfmail allows you to have a query attribute. Is there a way of having an additional 2nd query output within cfmail? Sebastian ~~ Structure your ColdFusion code with Fusebox. Get the official book at

SQL stored procedure and time insert

2000-12-28 Thread sebastian palmigiani
I cannot figure out why I am getting this error with SQL Server inserting a time value in a stored procedure. Anyone know why? ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type

This is weird

2000-12-28 Thread sebastian palmigiani
I am getting an ODBC error message. Below the message is saying that 'retreat' is a column name but it is not. It is the VALUE for the column name CommunityEventName. Any suggestions. I can't figure this out. Sebastian -- ODBC Error Code = 37000 (Syntax error or

Javascript validating input type=file

2001-01-03 Thread sebastian palmigiani
How can you use Javascript to validate an input type="file" field. The code below gets triggered no matter what -- even with a file in the browse input box. Any suggestions script language="JavaScript" function validate() { if (document.myForm.DirectoryFile.value == ""); {

Re: !-#include file=cfFile.cfm -

2001-01-04 Thread sebastian palmigiani
You can't do it. on 1/4/01 11:18 AM, Eric Fickes at [EMAIL PROTECTED] wrote: Hello all, Has anyone ever included a cfm file inside of a .html file? I've got an HTML page that I would like to include a small CF page inside of and I can't seem to get it to work. I've tried the following

Re: line breaks in cfmail

2001-01-04 Thread sebastian palmigiani
Use #Chr(13)# -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 04, 2001 4:23 PM To: CF-Talk Subject: line breaks in cfmail Hey all, I have this ongoing problem with line breaks not being respecting when formatting my email

Re: Multiple Select Lists

2001-01-05 Thread sebastian palmigiani
on 1/5/01 4:58 PM, Tomas Rofkahr at [EMAIL PROTECTED] wrote: Let's say an intrepid developer would like to be able to query this database and have the values returned to a new page with a new select list with the previously stored values then selected in the drop-down list. Is this what you

Re: Adam, you got to be kidding?

2001-01-19 Thread sebastian palmigiani
on 1/18/01 8:54 AM, Aaron Johnson at [EMAIL PROTECTED] wrote: Your assumption is that 98% of all users have scripting enabled. Reality, as always is different. I'd guess much lower, especially taking into consideration all the viruses and IE bugs over the last year where users, especially

Re: How to disable Back function on browser

2001-01-19 Thread sebastian palmigiani
Here is a script that will disable the right click button: SCRIPT language="JavaScript" !-- // No rightclick script v.2.5 // (c) 1998 barts1000 // [EMAIL PROTECTED] // Don't delete this header! var message="Sorry, that function is disabled." // Message for the alert box // Don't edit below!

case sensitivity in stored procedures

2001-01-23 Thread sebastian palmigiani
Can you do a case sensitivity comparison within a SQL Server stored procedure? I want to compare an input password and test that it has the same case as the password stored in the database. Sebastian ~~ Structure your ColdFusion code with

Re: case sensitivity in stored procedures

2001-01-23 Thread sebastian palmigiani
can you give me a hint? Sebastian on 1/23/01 11:34 AM, DeVoil, Nick at [EMAIL PROTECTED] wrote: Can you do a case sensitivity comparison within a SQL Server stored procedure? Yes. ** Information in this email is

Can anyone shed some light on this?

2001-01-24 Thread sebastian palmigiani
I am running CFStudio 4.0 on Windows 98 and SQL Server 7.0. Is there an issue with the cfprocparam tag not passing the value of the database variable to SQL Server? I get 0 records returned. However, when I use cfquery with the same SQL query I get the right result. I've made sure that I have

CF browser detection

2001-01-25 Thread sebastian palmigiani
Does anyone know how to detect the WebTV browser using ColdFusion? Which value of the CGI.HTTP_USER_AGENT would you be looking for? Also, I have seen discussions that WevTV spoofs Netscape. Sebastian ~~ Structure your ColdFusion code with

Re: Photo gallery custom tag?

2001-01-25 Thread sebastian palmigiani
on 1/25/01 4:58 PM, Chris Montgomery at [EMAIL PROTECTED] wrote: I have the exact same need, but my question relates to dynamically generating thumbnail images from the full-sized image files. Anyone know if there is a custom tag that can do this? CFX_GIFGD will do the trick. Sebastian

Re: Can anyone explain this?

2001-01-26 Thread sebastian palmigiani
These are "session cookies", which are not written to the "cookie" file, but exist in memory, but not necessarily between pages. DC - Original Message - From: "sebastian palmigiani" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent:

Setting a Cookie

2001-01-27 Thread sebastian palmigiani
The query MemberRoles returns 2 values: 2 3 !--- Set the query to a local variable --- cfoutput query="MemberRoles" cfset Roles = RoleID /cfoutput !--- Set the local variable to a cookie --- cfcookie name="CFRoles" value="#Roles#" Only one of the values is set to the cookie which in this

Re: Setting a Cookie

2001-01-27 Thread sebastian palmigiani
That was my reaction too. But I kept checking the value of the cookie with cfoutput and it had only one value. I ended up setting the query to a list and then setting the value of the cookie to the list and it worked. Sebastian on 1/27/01 10:19 AM, Philip Arnold - ASP at [EMAIL PROTECTED]

Changing mail spool path

2001-01-30 Thread sebastian palmigiani
I need to change the path to the CF mail spool. How do I go about doing this? I got the following error message: All or part of the path is invalid. (Filename=C:\COLDFUSION\MAIL\SPOOL\) I need to change it to: C:\CFUSION\MAIL\SPOOL\ Thanks, Sebastian

Re: Help with Tell Friend script

2001-02-01 Thread sebastian palmigiani
If the tell a friend link is on the page you want to send in the email then use #CGI.HTTP_REFERER# in the hidden input field. Sebastian on 1/31/01 9:09 PM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote: --part1_6b.f450db3.27aa2d86_boundary Content-Type: text/plain; charset="US-ASCII"

Re: JavaScript variables passed to ColdFusion

2001-02-03 Thread sebastian palmigiani
on 2/3/01 1:17 AM, Michael Gribbin at [EMAIL PROTECTED] wrote: How do I get variables generated by JavaScript to be recognized by ColdFusion? I would like to do different things based on JavaScript results. When ever I try to put a JavaScript variable into a CFSET or CFIF I get an error that

session variables timing out

2001-02-05 Thread sebastian palmigiani
I have a site with 2 sections. The members only directory uses the application scope with session variables and the general public directories are all html files without any application.cfm. If a user goes from the member site to the public site and is active in the public site does that

book review request

2001-02-05 Thread sebastian palmigiani
Anyone got a personal review of the baok Business Intelligence with Coldfusion Is it worth buying? Thanks, Sebastian ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives:

HTML/OS

2001-02-07 Thread sebastian palmigiani
Anyone know about ColdFusion users being wooed by HTML/OS http://biz.yahoo.com/bw/010205/ca_aestiva.html Sebastian ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives:

2 Dabase Questions

2001-02-11 Thread sebastian palmigiani
Does the foreign key in a table need to be indexed when that field is already indexed as a primary key? Also, if you have a linking table with 2 foreign keys should those 2 keys be combined to form a primary key for the linking table? Thanks, Sebastian

2 Dabase Questions

2001-02-11 Thread sebastian palmigiani
Does the foreign key in a table need to be indexed when that field is already indexed as a primary key? Also, if you have a linking table with 2 foreign keys should those 2 keys be combined to form a primary key for the linking table? Thanks, Sebastian

Database Indexing Primary Keys

2001-02-11 Thread sebastian palmigiani
Does anyone have any input on these 2 questons? Does the foreign key in a table need to be indexed when that field is already indexed as a primary key? Also, if you have a linking table with 2 foreign keys should those 2 keys be combined to form a primary key for the linking table? Thanks,

Re: Not letting me update

2001-02-11 Thread sebastian palmigiani
Joshua: Try removing the single quotes around the 1. I am assuming that the sold column is either set to a number or bit value in your database. If so that would explain your error. Sebastian on 2/11/01 5:45 PM, Joshua Tipton at [EMAIL PROTECTED] wrote: The id is being passed yet I am

Re: Validating Checkboxes

2001-02-21 Thread sebastian palmigiani
on 2/21/01 1:07 PM, Phoeun Pha at [EMAIL PROTECTED] wrote: Anyone have a good method in CF for validating checkboxes (grouped). Since the form gives you a comma delimited list of values of the boxes checked I would test with ListContains(variableName, variableValue). Sebastian

bold verity search terms

2001-02-21 Thread sebastian palmigiani
Any ideas on how you would make bold b the verity search term in an htm or cfm file that is returned from cfsearch? The one way I can think of is to use cffile to get the html file and then do a replace of the search term with bsearch term/b. Am I on the right track? Sebastian

Re: bold verity search terms

2001-02-22 Thread sebastian palmigiani
atch may be separated. You are on the right track. One thing that I have found is that parsing the content of the page and inserting it into the database and using that when indexing gives me a workaround for the fact that Verity does not index titles and descriptions. Parse between the title tags a

Re: local user time

2001-02-22 Thread sebastian palmigiani
on 2/22/01 9:23 AM, Ethan Rosch at [EMAIL PROTECTED] wrote: What's the best way to get the time off of the users local machine? The Now() fuctions pulls server time. You need to use javascript. Sebastian ~~ Structure your ColdFusion code with

Re: How to choose Name or Scope when locking

2001-02-22 Thread sebastian palmigiani
on 2/22/01 2:13 PM, Dave Watts at [EMAIL PROTECTED] wrote: Databases do this stuff for you; that's what transactional database processing is all about. I'd strongly recommend using transactions within the database to do this instead of CFLOCK. Of course, I suspect that you already know this,

Verity

2001-02-26 Thread sebastian palmigiani
Why is it that in the Summary variable in Verity sometimes HTML codes are shown and sometimes not? I have checked the pages where this happens and they are identical in terms of the image tag that is displayed in one summary and not in another. Also, how do you change the Score variable? I have

fusebox and cfcache

2001-03-02 Thread sebastian palmigiani
I have a question about using cfcache with fusebox. If I have an action like cfcase value="ShowSchedule" cfinclude template="Query_SelectSchedule.cfm" cfinclude template="Display_Schedule.cfm" /cfcase I want to use cfcache on Display_Schedule.cfm. The link would be listed as

Which is better?

2001-03-03 Thread sebastian palmigiani
Which is better in this situation: using application variables or cfcache? I have an application variable from a query which populates a select box. Would it be better to use cfcache instead? Sebastian ~~ Structure your ColdFusion code with

Stored Procedures

2001-03-05 Thread sebastian palmigiani
In a stored procedure how can you run a conditional query based on the value of a declared variable? The following does not work. DECLARE @PollType CHAR SELECT @PollType = PollType FROM Polls WHERE PollStatus = 1 -- Run query depending on PollType IF @PollType = 'YN' BEGIN

I'm stumped

2001-03-06 Thread sebastian palmigiani
I get the following error with a stored procedure. I am using CF 4.0. What is stumping me is that when I run the query in the analyzer it works. For example, this work: INSERT INTO PollMembers (PollID, MemberID, MyVote, LastUpdate) VALUES('MC-03-5-2001-14-33-22', 'PWOO2', 'A', GetDate())

Re: I'm stumped

2001-03-06 Thread sebastian palmigiani
on 3/6/01 6:45 PM, Bryan Love at [EMAIL PROTECTED] wrote: here's your problem... cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname="@PollID" value="TRIM(FORM.PollID)" you didn't pound the trim function :) Geez...You're right! I have been at it for hours with this trying to

Testing for NULL in stored procedures

2001-03-08 Thread sebastian palmigiani
I am working on a poll which allows multiple selections. How do I get this strored procedure to work? I am passing null values from the cfstoredproc tag and want to conditionally run a query depending n whether the value of the variable is NULL or not. I have tried NULL, NOT NULL, !=. With

Re: Testing for NULL in stored procedures

2001-03-08 Thread sebastian palmigiani
on 3/8/01 9:59 AM, Andy Ewings at [EMAIL PROTECTED] wrote: or rather! IF @ChoiceA IS NOT NULL Yep that did the trick. Thanks Sebastian ~~ Structure your ColdFusion code with Fusebox. Get the official book at

Re: Protecting an admin page

2001-03-08 Thread sebastian palmigiani
on 3/8/01 9:47 PM, Hubert Earl at [EMAIL PROTECTED] wrote: I have an admin page which can be accessed thru a login page. However, as it now stands, if someone were to learn bookmark that page, he or she could return to it via the bookmark, rather than via the login page. How can I ensure

RE: Protecting an admin page

2001-03-09 Thread sebastian palmigiani
on 3/8/01 9:47 PM, Hubert Earl at [EMAIL PROTECTED] wrote: I have an admin page which can be accessed thru a login page. However, as it now stands, if someone were to learn bookmark that page, he or she could return to it via the bookmark, rather than via the login page. How can I ensure

Re: Examples of Password protection

2001-03-10 Thread sebastian palmigiani
on 3/10/01 9:35 AM, Michael at [EMAIL PROTECTED] wrote: Looking for some examples of password protection of certain pages or view's Near the end of chhapter 17 of the book Mastering ColdFusion 4.5 by Danesh and Motlagh has a nice section on this. Sebastian

SESSION.URLToken

2001-03-11 Thread sebastian palmigiani
If you want to use session variables and you want to anticipate users not having cookies turned on is it correct then that you would need to use a SESSION.URLToken and not just a URLToken appended to each link? Why doesn't just having URLToken work? I tried it and I can't access the session

Re: SESSION.URLToken

2001-03-11 Thread sebastian palmigiani
on 3/11/01 7:50 PM, Dave Watts at [EMAIL PROTECTED] wrote: To the best of my knowledge, there's no local variable called URLToken. There is a URLToken that is activated only when clientmanagement is on. Sebastian ~~ Structure your

weird session variable behavior

2001-03-14 Thread sebastian palmigiani
I set a 2 element list to a session variable and retrieve the last element. This works ok on this page. cflock name="SESSION.SessionID" timeout="10" cfset SESSION.SponsorID = "HPRO1^The Human Process Inc." cfoutput#ListLast(SESSION.SponsorID, "^")#/cfoutput /cflock on subsequent pages I have

Re: weird session variable behavior

2001-03-15 Thread sebastian palmigiani
I have used other delimiters such as "|' and even the comma and still the same results. I have figured out that it has something to do with the development server on my machine because I put the pages up on the hosting site and it worked ok. It is errors like these that are so frustrating and

Re: OT: different link colours

2001-03-18 Thread sebastian palmigiani
on 3/18/01 12:16 AM, Seamus Campbell at [EMAIL PROTECTED] wrote: So how do I get the above links colours to ONLY work in bottom.cfm Try the style tag like a href="YourLink.cfm" style="color: YourColor;"YourLink/a The style tag must be included in each link. There are other ways to do it

database error

2001-03-21 Thread sebastian palmigiani
I don't understand the following MS SQL error. Both columns for the primary and foreign key are varchar(20). I don't know how to fix this error because I don't even know what it means as it is the first time for this one. Any help? Thanks, Sebastian --- - Unable to

  1   2   >