Recent content by jackied

Hello. I have posted the same probelm in the VB Win32(API) forum - thread711-918192 - and had no joy. Perhaps a crystal approach is more appropriate. I am trying to print to a PRN file from Crystal. I have set up a PCL printer (HP Laserjet 5 PCL) with FILE: as the port. I have selected this...

Hello. I am trying to print to a PRN file from Crystal. I have set up a PCL printer with FILE: as the port. I have selected this printer in my Crystal template. When I print it, a "Print to File" dialog box appears. I am trying to programmatically add the OuputFile name and click OK. I found...

INSERT INTO MyTable (MyDate, ... ) VALUES({ d '#DateFormat(Now(),"yyyy-mm-dd")#' }, ...) would be safer. This way there can be no confusion between month and day.

Hi Tek and pcorreia Thanks, I have re-ordered my parameters so that the output parameters are first, followed by those most likely to be passed, which is saving me quite a bit of parameter passing. However the paramaters passed vary as this stored proc is called from more than one place...

From experience and other threads I could find on the subject, Thread232-137754 Thread232-241900 It seems that you have to pass parameters in the correct order and that you have to pass all parameters explicitly, although some were declared as optional in SQL server. I have a SQL server stored...

Hi Chandler. Have you got CF5? If so you can do a query on a query. eg. <CFQUERY name=&quot;qryBottom&quot; datasource=&quot;#DatasourceName#&quot;> SELECT TOP 50 * FROM Table ORDER BY IDNum DESC </CFQUERY> then re-order this by querying the query <CFQUERY name=&quot;qryReOrder&quot...

I'm sorry - I really don't know the answer. If you have a client machine which you can experiment with, it might be worth giving the j2re-1_3_1-win.exe (from the sun site) a try. Uninstall other plug-ins etc. first and then download and run it. You never know!

You need to enter the date into ColdFusion in a date format that CF recognises (using slashes,dashes or long date formats), so that Cold Fusion can treat these as dates. The safest way to do this is by using the CeateDate function. <cfset DateEntered = CreateDate(2001,7,12)> <cfset...

OK, now I'm out of my depth. I have also found this whole thing very confusing. I installed that run-time environment on the client, as it was the jvm/plug-in (??) on the client was what was causing the problem. I only ever had that browser crashing problem on clients that had previously been...

Yes, I have. You need to install the Java 2 Runtime Environment v1.3.1 You can download it from http://java.sun.com/j2se/1.3/jre/download-windows.html The file is called j2re-1_3_1-win.exe Also there is an upgrade for the applets that come with CF5. It fixes some problems with the grid and...

Hi there. We have recently installed CF5 and our site uses CFTree and CFGrid. On some clients, loading these applets causes the browser to crash. We are using IE5 or IE5.5. Do we need an updated Virtual Machine? Has anyone else experienced these difficulties? Thanks Jackie

Hi Barbera. I assume &quot;date&quot; in the DateDiff statement is the field in your database. Whatever is between the cfquery tags is sent to the database to be processed. Because you have hashes around your DateDiff statement, CF will attempt to resolve this before going to the database...

Hi Wouter. Maybe this is too obvious but I notice that you are checking for the existance of the variable session.user_id in: <cfif NOT ISDEFINED (&quot;session.user_id&quot;)> but later set the variable session.UserID <cfset session.UserID = #form.id#> but then use session.user_id in your...

Hi wesix. I have found out how to do it. The key is to have a schema.ini file in the same folder as the text file which looks a bit like this: [myfile.txt] ColNameHeader=False Format=CSVDelimited MaxScanRows=1 CharacterSet=Ansi Col1=CustID Text Col2=Reference Text Col3=NumberofThings Integer...

I am trying to create a Linked Server in order to query the contents of a text file in SQL server. I can not seem to see a suitable option in the Provider Name list. Has anyone done this successfully? Could you tell me how you set the Linked Server settings, and if you had to install another...