>
> yeah! --- that is exactly what we've had to do in the past, but we need to
> automate and streamline...
>
> I've tried the readline tag, but it still seems to bomb after a certain
> amount of lines, not the same each time... unpredictable.
Just to be sure. Have you tried the CFX_ReadLine (0.
MS SQL Server Books On Line - search on:
Bulk Insert or Bulk Copy Command or BCP
Maybe create a sp and execute as follows?
The BULK INSERT statement can be executed within a user-defined transaction.
Rolling back a user-defined transaction that uses a BULK INSERT statement
and BATCHSIZE clause
> Using the @@IDENTITY variable isn't guaranteed to be
> correct under heavy load from my understanding.
thats an urban myth. it scales just fine.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
h
That is a good idea, but there will be 3 separate files from 150mb - 300mb
each that will need to be processed each day. Each record will have to be
updated/inserted/deleted from the db. So I'm trying for total automation
from the ftp retrieval to the complete db comparison.
:-(
It is becoming
If you are using database server in backend pls check connectivity with
database server. Also check the DSN configured in CF admin , means verify
the DSN. Check the log of server in CF admin where you will come to know
which file is not responding for CF server request. Is it happening to all
file
At 8:42 PM -0400 6/30/2000, Claude Raiola wrote:
>my database is currently written in access 2000 as I seem to be having
>problems with upsizing feature in access 2000 into sql would I be better of
>purchasing sql desktop
>
>by doing so would sql desktop provide me the same compatibility and
>fun
Forget CGI. If your on a ColdFusion server use CFMail and output the
results straight into that and away you go... check it out.
HTH
Bill
> -Original Message-
> From: jordan [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 30, 2000 10:54 PM
> To: [EMAIL PROTECTED]
> Subject: could anyone
On 6/30/00, Joseph J. Sanger, M.D. penned:
>I have created a form that has a text type input field on it, and I
>am saving it to an Oracle Database. If a double quote is used in the
>text field, it saves properly to the database. However, when I read
>it back in, although it is returned from the
This is a multi-part message in MIME format.
--=_NextPart_000_0027_01BFE2E6.1B060CC0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
i was creating a form for people to sign up for a mailing list and for a =
short survey on stuff they would
Does anybody know what might cause the following errors? My templates were
running just fine and I haven't changed a single line of code on them. The
site is in a shared hosting environment so I suspect that something has been
done by someone else to cause these errors but what!?? Can anyone kind
Im coming into this thread late (maybe missed a reply or two) but have you
looked at Nate's tag...? Allows you to read in a certain
numbers of rows for processing etc...pretty nice tool...
http://www.icesinc.com/nate/taggallery/CFX_CSVToQuery/CFX_CSVToQuery.html
-
Actually your wrong, but right. Your right about the CFFile part, however
once the forma has ben submitted the file gets attached to the packets of
other variables going across. then its upto CFFile to take it from the sent
variables and saves it to the HD.
-Original Message-
From: Jeff
Jeff,
CF won't see ViewField6 as being from the query GetRecord. CF will see it
as a simple variable. This has to do with the concept of scoping of
variables. Check the online help for more information. To address the
field from the query, use:
One other bit of advice is to not use Paramet
Duh.
Works perfect. Thanks!
Jeff Fongemie
-Original Message-
From: Howie Hamlin [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 30, 2000 9:58 PM
To: [EMAIL PROTECTED]
Subject: Re: Why won't my work with this??
Try:
Regards,
Howie Hamlin
--
inFusion Project Manager; On-Line Data Sol
Try:
Regards,
Howie Hamlin
--
inFusion Project Manager; On-Line Data Solutions, Inc. (631)737-4668
www.CoolFusion.com
Please vote for iMS in the Most Innovative category here:
*** http://www.sys-con.com/ColdFusion/readerschoice2000/
This looks so simple, am I missing something obvious? I can't get the to work.
SELECT news.headline AS ViewField1, news.news AS ViewField2,
news.date_entered AS ViewField3, news.blurb AS ViewField4, news.photo AS
ViewField5, news.live, news.live AS ViewField6, news.newsID AS ID_Field
Hi Tom,
I seem to recall that someone posted to this list a few weeks ago saying
that there were no problems at all with using the @@IDENTITY method of
getting the Identity Column. I've certainly used it ever since I've been
writing stored procedures and have never experienced any problems, eve
joseph,
:
: From: "Joseph J. Sanger, M.D." <[EMAIL PROTECTED]>
:
: I have created a form that has a text type input field on it, and I
: am saving it to an Oracle Database. If a double quote is used in the
: text field, it saves properly to the database.
From: lsellers <[EMAIL PROTECTED]>
> >
> > I know there are some image-oriented CFX tags and the like out there - but
> > I'm curious if anyone knows of an existing tool/tag that could grab a GIF
> > file, set a certain RGB color within that GIF file to be transparent, and
> > resave the file
Unless you're using an Array to store the shopping cart values. In that
case, you're probably looking for ArrayLen. If it's a structure, I'm
thinking StructCount is your function.
Jesse D. Roberts
Business Process Analyst
Procurement Quality Assurance
Boeing - Huntington Beach, CA
[EMAIL PROTEC
From: Scott Weikert <[EMAIL PROTECTED]>
> I know there are some image-oriented CFX tags and the like out there - but
> I'm curious if anyone knows of an existing tool/tag that could grab a GIF
> file, set a certain RGB color within that GIF file to be transparent, and
> resave the file. Preferab
Billy,
Thank-you for the advice and link! Well said, Doug!!!
Thanks, Christine
I'm a CF newbie and non-programmer who has been helped out of several CF
jams on this list. I consider it a valuable resource not to be misused
or taken lightly.
Doug Jordon
"Gary M
Does it have to be fast? You could use VBA in Excel to read the file in
which would allow you to separate it to multiple sheets (without cutting up
the text file itself) for later import into Access or SQL. Or even VBA in
Access I suppose to read the file and do inserts. The VBA into Excel
woul
>
> I know there are some image-oriented CFX tags and the like out there - but
> I'm curious if anyone knows of an existing tool/tag that could grab a GIF
> file, set a certain RGB color within that GIF file to be transparent, and
> resave the file. Preferably something like a CFX tag that I can
>
Mark,
That was it. Thanks so much. You just saved me the time of sifting through
documentation without really knowing what I was looking for.
Jeffrey A. Zubeck
- Original Message -
From: Mark Warrick <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 30, 2000 3:37 PM
Subject
Sounds like it could be a problem in a specific template. Make sure you
don't have an infinite loop.
At 06:08 PM 6/30/00 -0400, you wrote:
>That's weird...Suddenly, it's working again! ugghh
>
>___
>Robert M. Saxon, Jr. (Rob), Senior Web Developer
>Mercer
You're probably thinking "ListLen()".
---mark
--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net
Business Email: [EMAIL PROTECTED]
Business URL: ht
Hey gang -
We're working on ways to revise a mapping tool that's on our site. One
thought involves using a transparent GIF overlaying another GIF
(non-transparent) using layers. The application we use currently, as far as
I know (this is being looked into) generate transparent GIFs.
I know there
I am drawing a blank on this, and I know it's something simple that I've
just forgotten...
I need to find out the number of values being stored in a session variable
to determine a quantity discount in a shopping cart. How do I dynamically
gather that number?
Thanks,
Jeffrey A. Zubeck
In the CF Administrator, under the Server Settings section, change or
uncheck the Timeout Requests after... setting. You can either increase it
or turn it off. However, I would also investigate what is causing a request
to take longer than 30 minutes! I mean, has your database gone out to lunch
That's weird...Suddenly, it's working again! ugghh
___
Robert M. Saxon, Jr. (Rob), Senior Web Developer
Mercer University
Department of Web Management
-Original Message-
From: Mark Warrick [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 30, 2000 5:5
I have created a form that has a text type input field on it, and I
am saving it to an Oracle Database. If a double quote is used in the
text field, it saves properly to the database. However, when I read
it back in, although it is returned from the database properly, when
I try to redisplay
Hi,
Here's what I was told. Does this help?
It will compromise the performance of the server somewhat, but it is the
only way to deal with the dilemma that is the employee discount program.
At issue of the sheer size of the file, over 65000 characters long. SQL is
simply not retrieving all o
In cold fusion administrator, turn on "log slow pages" and set it for 60
seconds. This will log slow pages. This is a start. If the page in
accessing a database, check the database also.
What are you trying to do that takes more than 1800 seconds?
At 05:49 PM 6/30/00 -0400, you wrote:
>I su
yeah! --- that is exactly what we've had to do in the past, but we need to
automate and streamline...
I've tried the readline tag, but it still seems to bomb after a certain
amount of lines, not the same each time... unpredictable.
GRR.
je
> -Original Message-
> From: Mark Warri
Yuck. Doesn't sound good!
So, it doesn't matter which template you access?
Try creating a simple "hello world" script and see if the problem still persists.
You might have to reinstall the ColdFusion server.
---mark
--
Mark Warrick
could you please elaborate on "yes"
for example with sql desktop work on win 98 or does it require nt and are
there any limitation of using the sql desktop in terms of full sql
functionality or is that the reason for sql desktop ???
- Original Message -
From: Jim Taylor <[EMAIL PROTECTED]
could you please elaborate a little more on "yes"
- Original Message -
From: Jim Taylor <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, July 01, 2000 7:35 AM
Subject: RE: Help SQL Desktop V's SQL Server
> yes
>
>
> -Original Message-
> From: AustralianAccommodation.
I suddenly started getting this error a few minutes ago anytime I access a
CF page. I tried to stop/restart CF services...no dice. Also tried the
same with the web server. Has anyone else seen this before?
Error Diagnostic Information
The time taken to process your request has exceeded the al
yes
-Original Message-
From: AustralianAccommodation.com Pty. Ltd.
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 30, 1999 2:08 PM
To: [EMAIL PROTECTED]
Subject: Help SQL Desktop V's SQL Server
my database is currently written in access 2000 as I seem to be having
problems with upsiz
I'm having a hard time with your terminology.
Do you own SQL Server? If so, what version? Is it installed? If so, What operating
system are you using?
---mark
--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Per
>> I am hereby giving notice that I am tired of being polite. I will wait 48
>> hours and if I am still on the list I will implement large volume
>> programmed "posting" until my postings are no longer accepted.
Hmmm... You say that you work for a marketting co. Why in hell did you
subscribe to t
There's another way with SQL Server using a trigger:
CREATE TRIGGER GetPK_MyTable ON MyTable
FOR INSERT
AS
SELECT MyTable_ID FROM INSERTED
When you do your CFQUERY and perform the SQL INSERT,
SQL server will return the inserted ID via the trigger!!!
Using the @@IDENTITY variable isn't guarantee
my database is currently written in access 2000 as I seem to be having
problems with upsizing feature in access 2000 into sql would I be better of
purchasing sql desktop
by doing so would sql desktop provide me the same compatibility and
functionality that the upsizing feature does using access 2
any idea where I can go and find out those fields that sql has problems
converting form access and then what I need to use as the alternative
- Original Message -
From: Sean Renet <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, July 01, 2000 2:11 AM
Subject: Re: Help With Upgra
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> I am developing an application that will be
> accessable in multiple languages. I would
> like the application to be able to identify the
> location of the client and present them with
> the page in the proper language.
>*snip*<
> Does anyone
how do I paste in tables and then what corrections do I need to make to
primary keys and ntext fields what is a ntext field anyway ??? sorry I am
totally new to sql no nothing about it was wanting to use the access 2000
interface so that basically I would not need to learn about the new database
p
I take back what I said earlier. This is news to me! Thank you.
I tried this and it works.
---mark
--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick
Hi Billy,
Thank you. That works fine. I can now turn it off for templates that are
debugged. Have a nice day.
Regards,
Paige
- Original Message -
From: Billy Cravens <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 30, 2000 3:05 PM
Subject: Re: Debug Data
> View it fro
Hi Sharon,
Thank you. That works fine. I can now turn it off for templates that are
debugged. Have a nice day.
Regards,
Paige
- Original Message -
From: Sharon DiOrio <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, June 30, 2000 3:03 PM
Subject: Re: De
Larry, thank you...worked like a charm.
Yes you can query the sheet:
SELECT WhatevercolumnNames
FROM `Sheet1$`
WHERE this = this
You have to be certain of the reverse single quote before the sheet name and
after the dollar sign.
H Larry Juncker
L Senior Cold Fusio
Interesting idea, Mark...
But I'd have to say it's not a good one, ESPECIALLY over the July 4th week
:)
'Sides, why should a thousand other people suffer because one person has a
potty mouth, poor communication skills, and a general lack of respect for
others
Just my measly 2 cents on a di
This is a multi-part message in MIME format.
--=_NextPart_000_0055_01BFE2B0.0943E830
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I am developing an application that will be accessable in multiple =
languages. I would like the applicatio
I ran into the same problem in the past with a 50 MB text file that I need to import
into SQL.
I tried making it a spreadsheet and importing to Access first, but it cuts of at
something like 65,000 lines. Same problem with importing directly into Access, it
just bombs. Also, I tried importin
> I have a rather large text file (145mb) that I need to read into a dB.
>
> The part I'm having trouble with is the READING of the file part. I am
> using a line by line tag from the dev site to read in say 1000 lines at a
> time, but some times it bombs at line 500... then I'll run it again an
Yes you can query the sheet:
SELECT WhatevercolumnNames
FROM `Sheet1$`
WHERE this = this
You have to be certain of the reverse single quote before the sheet name and
after the dollar sign.
H Larry Juncker
L Senior Cold Fusion Programmer
I Heartland Communications
| - has been around for 15 years (it's used by US Army for the M1 tank and
| a host of others)
| - recently announced it's release as open source (it's not yet released
| but should be very, very soon).
Woohoo .. open source tank software. YES! Now I can finaly upgrade my
Panzer.
Todd
--
I have a rather large text file (145mb) that I need to read into a dB.
The part I'm having trouble with is the READING of the file part. I am
using a line by line tag from the dev site to read in say 1000 lines at a
time, but some times it bombs at line 500... then I'll run it again and it
works
Forgive me for sounding silly here, but, why bother with Excel when you could just use
Access?
Just for grins, I setup an Excel spreadsheet as an ODBC datasource. I tried accessing
the "table structure" with my CF Studio. It sees nothing. I ran a query against one
sheet within the work book
This is a multi-part message in MIME format.
--=_NextPart_000_0008_01BFE2AB.860AC140
Content-Type: multipart/alternative;
boundary="=_NextPart_001_0009_01BFE2AB.860AC140"
--=_NextPart_001_0009_01BFE2AB.860AC140
Content-Type: text/plain;
charset="iso-8859-1"
Content-T
Dude,
You need to take a chill pill or something. Obviously you're not interested in
discussing ColdFusion related topics and frankly if you were I don't think anyone
would answer your questions after you threatened all of us for the past 2 days.
If you haven't got a clue what e-mail address
All,
Having done some comparison of both mySQL and PostgreSQL, I would
STRONGLY recommend that you have a look at Interbase SQL Server
(www.interbase.com).
- it supports 98% of possible OS's (NT, Linux, Unix...)
- it is a true SQL server (with transactions, triggers, Stored
Procedures, referenti
I'm trying to connect to an Excel spreadsheet. I've created the datasource
and it verified fine. Can I use cfquery to access the datasource? If so,
can someone help with syntax?
TIA,
Tom
--
Archives: http://www.eGroups
The list manager has responded and he let you know that the address that
you are trying to use to unsubscribe is not subscribed. Until you come up
with a subscribed address you can't be unsubscribed. He said this yesterday
after he came back into the country from teaching classes. As for your n
Give it up Michael, we know its just you trying to keep us from leaving :-P
- Original Message -
From: "Michael Dinowitz" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, June 30, 2000 8:22 AM
Subject: Re: Unsubscribe
> Let me try this again. I've gone th
www.guru.com has some good legal info for independent contractors. It doesn't replace
a lawyer, which if you're serious about presenting a contract to anyone, you should
consult
with.
--
Billy Cravens
[EMAIL PROTECTED]
Christine Kelley wrote:
> Hi all!
>I am finishing up a couple small
Sorry, it's not clear to me. What exactly are you trying to do?
--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net
Business Email: [EMAIL PROTECTED]
It makes you feel so welcome to have a greeter like Papa Dave at the door.
Kind of like what Wal-Mart wishes it could do.
--John
Douglas
View it from another ip address that isn't in the debug list. Or, at the top of your
page:
Of course, you could always go into CF Administrator and disable debugging altogether.
--
Billy Cravens
[EMAIL PROTECTED]
Paige Chandler wrote:
>
> Hi All,
>
> I have debug data appearing at the botto
Or you can turn off debugging entirely in the cfadmin.
Sharon
At 02:50 PM 6/30/2000 -0400, Paige Chandler wrote:
>
> This is a multi-part message in MIME format.
>
> --=_NextPart_000_000B_01BFE2A2.8434DEE0
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding:
This is a multi-part message in MIME format.
--=_NextPart_000_000B_01BFE2A2.8434DEE0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi All,
I have debug data appearing at the bottom of my web page when I access =
it via the browset for tes
LOL,
Why didn't I think of that?
Well, i'm just an idiot - just spent half the day on it and you got it in 2
seconds.
Thanks a million, you're a life saver!!
Perry
on 6/30/00 11:06 AM, Howie Hamlin at [EMAIL PROTECTED] wrote:
> Do you have a tag in your application.cfm?
>
> Regards
When referential integrity is enforced by the database the logic you program into your
application must also manage referential integrity properly, or your users will see
errors returned
from the database whenever referential integrity is violated. So if you do a good job
of writing your appli
I ran across this little factoid in my email
accounts on my own Post.Office mail server.
Regardless of what I tell Eudora my return
email address is, some list servers won't allow
me to post to the list unless I subscribe
the "Primary E-Mail Address" as defined in the
Post.Office account setup.
On 6/29/00, Billy Cravens penned:
>Hehe...
>
>Check out their site, www.ivh.com
>
>To avoid being unprofessional/tacky, I won't make any comments.
>Draw your own conclusion.
LOL
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce
Do you have a tag in your application.cfm?
Regards,
Howie Hamlin
--
inFusion Project Manager; On-Line Data Solutions, Inc. (631)737-4668
www.CoolFusion.com
Please vote for iMS in the Most Innovative category here:
*** http://www.sys-c
Has anybody else encountered this problem?
When I do a it outputs an unwanted
tag on the top of my pages.
There are absolutently no tags in my file... I've isolated my files to
just this
index.cfm
-
heading.cfm
---
nothing
alsdfjlsadjf
and it still attaches a t
I believe you would just run two queries at the same time.
Or am I missing something here?
--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net
Busine
Hello all you coders,
i have the following problem:
a customer shall make an entry to a database where the entered data gets to
table A. This is surely simple and already works fine :). Now I try to
update a record in another table B (where the customers infos are stored).
There is a field conta
btw, whatever happened to cfbugtraq.co? It keeps ending marked "dead" in my
books. Is it just me or is it rally dead?
--min
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.
There are a couple of ways, some more preferred than others.
Option 1 (Best for Beginners and Learning, can sometimes give erroneous
results)
Perform the insert into the database. My assumption is that you are using an
Identity field, like the Autonumber field in Access or Identity in MS SQL
Ser
Thanks to Seth, James & Dan for the advice!
I have plenty to chew after the long weekend :)
Dana
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lis
I am taking information from a database and using cffile and appending the
info. My problem, some of the information contains html to format the text
on the screen. But, in the Excel file that is appended, I do not need the
html, therefore it needs to be taken out. I would assume I use ReRlace,
> The first idea was pretty dumb (although I prefer to call it 'Rapid
> Prototyping'), which was to run the query on each page, store the results
in
> an array, and then print out the appropriate 10 with .
First of all, there are a number of custom tags in the Allaire tag gallery
that let you do
I'm a CF newbie and non-programmer who has been helped out of several CF
jams on this list. I consider it a valuable resource not to be misused
or taken lightly.
Doug Jordon
"Gary McNeel, Jr." wrote:
>
> I could not agree with you more, John. I am on several lists and this is BY
> FAR the best.
It's settled, to hell with using the array idea - I've resorted to using a
temp table in the database. Maybe I'll see if I could apply a stored
procedure to hurry things along - that should be a fun project seeing as I
have never written one yet. I still, however, would like to know if
somebody
It's in your browser settings. In IE, go to
File > Page Setup > and change the info in the Header / Footer parts.
There might be a programatic way to do it, but I don't know it if there is.
Todd Ashworth
- Original Message -
From: "Doug Powell" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECT
I know its an @@id when looking it up in a stored proc
-Original Message-
From: Jason Zimmerman [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 30, 2000 12:35 PM
To: Cf-Talk (E-mail)
Subject: return value of Identity Column
Is there a way to return the value of an Identity Column after an
It sounds like an acceptable solution for a limited number of users -- but
it could get to be resource intensive quickly; I don't know how CF handles
heavy memory requirements like this. One thought is that you'll almost
certainly want to use to protect your session variables as
youl load them
Dana,
The easiest way to cache the query is with the 'cachedwithin' attribute of
. For example would cache your query for 30
minutes. The only time the page will be slowed down is every 30 minutes
when the query refreshes, and the caching time can be changed easily
depending on how often your
This is a multi-part message in MIME format.
--=_NextPart_000_0052_01BFE292.4F8545A0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
A little off the subject here but anyway, when displaying
a form and telling the end user to print the page
Try the DateDiff Function...
Neil
- Original Message -
From: "Kurt Wiersma" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 30, 2000 12:49 PM
Subject: Comparing Dates in CFIF
> I am try to construct a table which has all the events for a particular
week
> listed by date
I am try to construct a table which has all the events for a particular week
listed by date each event occurs. I have tried the code below but have not
gotten
any records from the db to show up dipite have the correct dates entered in.
I cannot seem to get test for two dates equal on another or b
Is there a way to return the value of an Identity Column after an insert
into a SQL db?
Thanks,
-Jason
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=
You're actually going to try to justify your threat to mail bomb this list
by laying blame on the list managers? With all due respect, that kind of
behavior is totally unacceptable.
What would you do if the IRS upset you? Blow up their building? Geez I can
only imagine what would happen if McDona
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--_=_NextPart_001_01BFE2B0.B2631C10
Content-Type: text/plain;
charset="iso-8859-1"
http://belps.freewebsites.com/index2.htm
Great story about how t
Yes, here's the query:
These let the single quotes into the databasewithout these the insert
errors out.
This is the query doing the insert..
INSERT INTO tblJobListings(PostingID, MemberNum,
ExpirationDate, Title,
Area, Experience, Edu
I seem to get it everytime I do it, even after I've checked to make sure the
fields were named correctly. So I've lately just been pasting in the tables
and correcting the primary keys and ntext fields. Prolly a better way, but
it's fairly quick and painless.
Joel
"Russell, Bonnie" <[EMAIL PROTE
Malcolm,
A good way is a Index Server, we use it in our PDF workflow, and its cheap,
or free i think :)
-Original Message-
From: malcolm mcatee [mailto:[EMAIL PROTECTED]]
Sent: 30 June 2000 16:06
To: [EMAIL PROTECTED]
Subject: Decentralized Publishing---Verity?
I am working on a Intran
For me, that was memo fields. I would use a SQL statement for those tables
with memo fields and then upsize the rest automagically.
- Original Message -
From: "AustralianAccommodation.com Pty. Ltd."
<[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 30, 1999 7:18 AM
Subject
1 - 100 of 146 matches
Mail list logo