Search results for query: *

I have some SQL Server 2008 databases hosted on a remote server. One of the databases has an employee table with x number of fields. A customer has supplied me with an excel spreadsheet which contains a large number of number of employee details which need updating. The Excel spreadsheet...

Please help. I am new to Crystal reports and am trying to connect to a database on a SQL Server 2008 installation running locally. I created a new connection OLE DB (ADO) and then chose Microsoft OLE DB Provider for SQL Server. I get the error message below. Logon failed Details: ADO Error...

I am using Outlook 2000. I can find no way of turning on the "out of office assistant". I would appreciate any help in doing this. Thanks in advance.

I am designing a site which will be displaying clothes. There will be a administration and a user module. Each clothes item is available in a maximum of 10 colours. The administrator has to have the ability to define the 10 colours. I have 1 table which contains all the item fields and another...

Hi, I have problem inserting data into my SQL Server db using Coldfusion MX. When I insert the "£" symbol to denote GPB, in the data, the data is prefixed with a "Â". Is this a known issue. Any help or fixes would be appreciated. Thanks, Mary

Hi, I have been doing cfquery along the lines of <cfquery name=&quot;xxxx&quot; dataSource=&quot;xxxx&quot; username=&quot;xxxx&quot; password=&quot;xxxx&quot; dbserver=&quot;xxxx&quot; dbname=&quot;xxxx&quot;> select * from xxxx </cfquery> on CF 4.5. It has been working fine. On CF MX, the...

Hi, Is it possible to include an ASP/VBScript page within a Coldfusion page. This would save me having to rewrite the ASP page into a Coldfusion page, something I would like to avoid. Thanks, Ravi

Hi, Can someone tell me how &quot;ODBC Socket Data Source&quot; works. For instance, in the store exampleapp that is shipped with Coldfusion MX, how is the datasource created and where is the database and the tables. Thanks in advance, Ravi

Hi, I have a variable, thumb_xxxxx, that is returned from a db. I want to write something that will remove the first 6 characters, leaving just the xxxxx, that is then processed. Can anyone help. Thanks in Advance, Ravi

Hi, I am building a site that lists prices in British pounds. I want to be able to convert the prices in Euros too. Does anyone know of a way to get the current exchange rate from somewhere else dynamically and use that to display the prices in Euros. This would be preferable to writing some...

Hi, I hope this decription of my proplem makes sense. I am making a administrator and a customer page for an inventory checklist. The administrator can add/edit/delete records on the administrator page. The customer can view the updated page and checks a 'Yes' or 'No' radio button against each...

Hi, I am a basic Flash user modifying a scroller that I downloaded. It can be seen at http://www.ram-its.com/movietest/scroller.html, the fla is at http://www.ram-its.com/movietest/scroller.fla. I want to link each of the images to an external file. Can someone please help. (Flash 5). Thanks...

I want to search for a string(&quot;) within a table and replace it with another string(in). I am using a SQL Server db. Can someone please help. Thanks in advance.

Hi, I am working on a site where a user inputs certain details and submits. I then have some scripts which process the order and should then generate a pop-up window showing the input details. Variables are then cleared and returns the user to the home page. Generating the pop-up window as...

Hi, I hope this makes sense. I am writing a page which outputs all properties which falls between two rental values. The URL of the page would be view.cfm?rent1=100&rent2=400 I also have code in there which restricts the number of results to 10 per page. <cfparam name=&quot;page&quot...

Two questions. 1, I have a routine in my code, which checks if a certain image file exists. If it exists, it should display it, else, display a default image location. (code below). What happens is that, if it does find the image, it displays it, if it cannot, it still shows the same location...

I am using CFDIRECTORY to display the contents of a directory, but I want to pass the value of a variable into the path. I have tried the method below, without success. <cfset #test# = &quot;e:\web\xyz\#variable#\images&quot;> <CFDIRECTORY directory = #test# NAME=&quot;myDirectory&quot...

Stupid question. I want to add a variable, in the case below #productnumber#, to a string(.jpg), to create a new variable(image). i.e. <cfset #image# = #productnumber# & .jpg> I cannot get the syntax right. Can someone please help me to retain what is left of my sanity. Thanks in advance.

I need to insert the time of a form submitted by a user, into my SQL server DB. My host is in a different time zone to me by 5 hours. I do n't want to use the client time either, as that would introduce lots of other issues. How can I :- a)compensate for the 5 hours, bearing in mind that this...

Can anyone please help. From a menu, I call a cfm page containing my templates and header. Contained within this page, I want to insert an iframe page that contains the search results for the variable passed from the menu. Does that make sense to you ? If so, please help.