Datasource
I am trying to enter an SQL string into a function for my ASP page which works fine(see below):
Datasource='<%# Getdataset("Select Player_id,Player_Forename + Player_Surname as Player_Name from tblplayer",DSplayer_ID) %>'
However what I want is to have a space between Player_Forename and Player_Surname, normally in SQL I'd just write + ' ' + but this doesn't work and neither does + " " +. I'm sure this is probably a really simple problem but does anyone know what the correct syntax is?
View Replies
I created a stored procedure (sp) in my sql database. The sp accesses a table in another sql database. I ran the commands to add the linked server and add the linked login. The tests work fine within the database. Using Visual Web Developer, I'm trying to link my Sqldatasource control to this sp and I'm getting the error: "Could not find server 'xxx' in sysservers. Execute sp_AddlinkedServer to add the server to sysservers." Can you tell me how to fix this error?
View Replies
View Related
I Am new to ASP and I wish to create a dynamic datasource:
<%
Set test1 = Server.CreateObject("ADODB.connection")
Set DS_Path1 = Request.Form("Database_Path")
Set DS_Path2 = Request.Form("Database_Name")
DS_Path = DS_Path1&DS_Path2
test1.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:cfusiondatabase est.mdb;User ID=; Password=;"
%>
I want Datasource to equal DS_Path and not c:cfusiondatabase est.mdb
If I put in Data Source=DS_Path; it doesnt work.
View Replies
View Related
I need a way to extract data from an excel worksheet and write it to a table. is there a way i can tell it to only select certain parts of the sheet?i'm looking to copy the data and only the data, if you look at the attachment you will see i have an header and a legend. i don't want either.
i think i've tried this before, but i think i ran into permission problems? Can someone give me some guidence on this.
View Replies
View Related
Can I use an Excel file as a datasource like using a .mdb in a .asp? If yes, how can I do that?
View Replies
View Related
Im working with a CF driven dinamic site called 'Reconquista', and the datasource it uses is a Coldfusion one.
I need to access a non-CF datasource, from another site called 'Peru', and recover some information to insert in the datasource of 'Reconquista'.
That module can't be programmed in CF, because CF (as I know in this moment) does not acess any other datasource format rather than CF's one, and the datasource Im searching for (in Perú) is a common, MSAcess-driven datasource.
I thought the module can be programmed in ASP, but I dont know how can I made a connection to the CF_Datasource of 'Reconquista' in that language.
¿Is there any form of doing that?
A way to do that would be entablishing a DSN-Less Connection in CF, but that seems impossible.
View Replies
View Related
