://www.hallofsports.com
.. . . where the legends live on
> -Original Message-
> From: Russ Conway [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 25, 2001 2:43 PM
> To: CF-Talk
> Subject: RE: To Join or not to join that is the question- and if so how
>
>
> Write your query using
Write your query using IN so it looks like this...
select tblCandidates.*
from {oj tblCandIndExp LEFT OUTER JOIN tblCandidates ON
tblCandidates.intCandidateID = tblCandIndExp.intCandidateIDFK}
where 0=0
AND tblCandIndExp.intIndustryIDFK IN (1,15)
AND tblCandIndExp.intCandIndYrs IN (2,3)
Order by
First 12.5k rows is not very many. I've worked on SQL Server apps with
closer to 1 million rows. If you index the tables correctly and run
reasonable queries, I'd be surprised if you taxed the server too much.
As an alternate strategy though, you could do this with one table. Just
create a field
Use DESC...
SELECT FIELD1
FROM TABLENAME
ORDER BY FIELD1 DESC
Russell Conway
HallofSports.com, Inc.
351 West 22nd Street
New York, NY 10011
P (646) 638-2500
F (561) 423-2674
http://www.hallofsports.com
.. . . where the legends live on
> -Original Message-
> From: ibtoad [mailto:[EMAIL P
CREATE TABLE ForumID
(ForumID INTEGER NOT NULL IDENTITY (1,1) PRIMARY KEY CLUSTERED,
CategoryID INTEGER DEFAULT '0')
Russell Conway
HallofSports.com, Inc.
351 West 22nd Street
New York, NY 10011
P (646) 638-2500
F (561) 423-2674
http://www.hallofsports.com
.. . . where the legends live on
Does the insert need to be done in Cold Fusion? What about BCP (for SQL
Server) or SQL Loader (for Oracle)? We usually load the data into "stage"
tables using the load utility from the database and then run stored
procedures to clean the data and insert it into the production database. You
could a
> Is there a sample table structure available to be able
> to create a table on MS SQL when moving the client
> variables storage to a database from the registry?
CF creates two table CDATA and CGLOBAL and related indices...
CREATE TABLE CDATA
CFID CHAR (20),
APP CHAR (64),
DATA LONG)
> I'm trying to insert a date into an Oracle table and get the following
> error. Help!!
>
> Error Diagnostic Information
> ODBC Error Code = 37000 (Syntax error or access violation)
> [Oracle][ODBC Oracle Driver][Oracle OCI]ORA-00917: missing comma.
> SQL = "INSERT INTO emirf (FIRST_NAME, REQUE
Check out selfpromotion.com. It's a good starting point and free to use at
first. If you like it, I think they ask for $10 to continue using the
service.
Russell Conway
HallofSports.com, Inc.
351 West 22nd Street
New York, NY 10011
P (646) 638-2500
F (561) 423-2674
http://www.hallofsports.com
..
> Has anyone had trouble with CF eating the processor time on NT
> Service Pack
> 6a? It doens't happen all the time, just occasionally (about 1-2
> times per
> day) and I end up having to stop and start the CF service. Any ideas?
I e-mailed Douglas the suggestions posted to the thread "CF Usin
My server developed a problem today. CFServer.exe is using almost all of the
available processing time. I've tried stopping and starting the services and
the NT box, but as soon as I start CF again it almost immediately grabs all
of the processor time.
I'm running NT and CF 4.01. We've had this a
Normalizing the database will reduce the size of the database and help
ensure that the data is clean and consistent. But if you're concerned with
performance, typically you would "de-normalize" the database.
You might consider buying a book on modeling. Anything written by Ralph
Kimball is pretty
> Can cfhttp access to https site and get the files with username
> and pasword
> provided?
https://www.blah.com"
method="GET"
port="443"
username="DOMAIN\USERNAME"
password="**"
resolveurl="TRUE"
throwonerror="YES">
I've been following
> Querying 2 tables, and I want to order the results from the
> viewed_numbers.times table, in descending order. So I did this
> (using * as
> the tables are both small)
>
>
> SELECT * FROM advert_details, viewed_numbers
> WHERE advert_details.ID = viewed_numbers.adID
> ORDER by times DESC
> alright, i'm trying to create a "previous/next" statement so that
> my query only grabs 6 records at a time.
How about using a cursor and submitting the ID of the last record processed
as a parameter to the stored procedure? Then just loop through the results
until you hit the ID passed to the
For development I like TOAD (http://www.toadsoft.com/). There is a
downloadable demo you can try out. If you're talking about database
administration, I prefer DBArtisan (http://www.dbartisan.com).
Russell Conway
HallofSports.com, Inc.
351 West 22nd Street
New York, NY 10011
P (646) 638-2500
F (6
> do you have any leads to documentation for implenting Source Safe with CF?
Allaire has an article about it...
http://www.allaire.com/handlers/index.cfm?ID=12588&Method=Full
Russell Conway
HallofSports.com, Inc.
351 West 22nd Street
New York, NY 10011
P (646) 638-2500
F (646) 638-3444
http://ww
Visual Source Safe can be used to compare files and show the differences. It
integrates pretty well with CF. IMHO, it's a good idea to use some version
control system anyway.
Russell Conway
HallofSports.com, Inc.
351 West 22nd Street
New York, NY 10011
P (646) 638-2500
F (646) 638-3444
http://www
The list discussed this yesterday under the Subject "daylight savings
time. CF is reporting the wrong value for now".
I found a work-around on the Allaire CF forum...
I fixed mine by disabling the daylight savings time option in Windows and
changed the time manually. Then CF recognized the r
Someone posted this to the Allaire CF forum...
I fixed mine by disabling the daylight savings time option in Windows and
changed the time manually. Then CF recognized the right time.
Russell Conway
HallofSports.com, Inc.
351 West 22nd Street
New York, NY 10011
P (646) 638-2500
F (646) 638-3444
h
> Anyone good with Oracle? A template that I thought was working now
> generates this message:?
>
> > Oracle Error Code = 2290
> >
> > ORA-02290: check constraint (VELO.SYS_C003412) violated
> >
> >
> > The error occurred while processing an element with a general
> > identifier of (CFUPDATE), occ
SQL Server can handle that...
DATEPART(datepart, date)
The weekday (dw) datepart returns a number that corresponds to the day of
the week, for example: Sunday = 1, Saturday = 7. The number produced by the
weekday datepart depends on the value set by SET DATEFIRST, which sets the
first day of the
I'm getting a timeout on my production server when I try to run code similar
to this:
http://www.hallofsports.com">
The code works fine on my development server. Is this due to NT
Challenge/Response running on the production machine? The files/directories
involved are not secured. Would the
> registry or database?
>
> which is better and why?
Database if you're planning on scaling the site. The registry will fill up
pretty quickly.
Russell Conway
HallofSports.com, Inc.
351 West 22nd Street
New York, NY 10011
P (646) 638-2500
F (646) 638-3444
http://www.hallofsports.com
.. . . where
> Well, no not exactly. I need to save the results of the query
> after they have been displayed to the user. the reason is that in
> order to use a component that we have to convert this to pdf, I
> need the results saved as an html file.
>
What about this? It does run the Cold Fusion code twice
> I have a question that I am not sure how to do. I have a form
> page that allows users to select search criteria. Once they are
> done selecting their criteria, they generate a reoprt based on
> what they chose.
>
> My question is, once the query has run to create the report, can
> I save the re
> I'm doing a select from three tables, and my query is timing out. The
> problem is probably coming from the fact that there is not always a
> record in the m.POS_ARC_HEADX table. Is there a way to restructure this
> query so it still checks the m.POS_ARC_HEADX but does not die if no
> record e
> I have a date field (completedate) stored in my database. I want
> to be able
> to pull out all of the records by a selected month for a
> month-end report.
>
> Is there an easy way of doing this? I've tried
>
> where datepart('m', completedate)='#month#'
>
> but I keep getting an "in
28 matches
Mail list logo
