Batch File: Passing A String Variable To Sql Script Results In Truncation
I have a batch file that takes variables from the cmd and passes them by sqlcmd to an SQL script. When I pass the variable 'MikeTestList' the script runs as expected with no problems. When I passed 'BulkTransferTest' I got an error message, 'The string or binary data will be truncated'.
Some testing has shown that I get the error when the string is anything above 12 characters. Is there a limit to the length of a string you can pass using sqlcmd from a batch file? Is there any way around it?
Also, if I have a space in the string, it only passes the string up to the space. I have tried to fill it with a '%' which then gets passed as is, so the % stays in place through out the script. Code:
View Replies
ADVERTISEMENT
I'm attempting to include a file within another file using Server.Execute. This works fine... however, I need to pass the value of a variable defined within the parent file to the one included via Server.Execute.
From what I've read, the included files are processed before the parent files, so it seems as though the variable is getting lost. Is there any way to internally (not relying on query string) to pass a variable to an included file?
View Replies
View Related
Security issues, warning messages, etc., aside,
what MIME-type combination do I need for and ASP to write a BAT file to the response stream?
e.g.
Response.Clear
Response.ContentType = "application/octet-stream"
Response.AddHeader "Content-Disposition", "attachment;filename=message.bat"
Response.Write("net send COMPUTER2 success")
Response.End()
This code does not work!
Which is surprising because in my current config, the following html works fine, and executes on the shell:
<A href="message.bat">test</A>
View Replies
View Related
We're trying to write an application that will allow a user to enter an id field from an ASP intranet page and when they hit the enter button, fire off a print job. The problem is, Adobe must be open as the items being printed are PDFs.
We tried firing off a print command using MS SQL cmdShell() (not sure if that is the exact name of the command) and it works, but it never completes. The process hangs in the database because, we think, it hasn't closed Adobe, therefore never coming back to the query. We wrote the query into an ASP page.
Adobe must be open or the documents won't print properly.
Does anyone have any suggestions to how we can automate this?
View Replies
View Related
how to call a batch (.bat) file from an asp file
View Replies
View Related
Was wondering if anyone had any suggestions on how to execute a local batch file by simply pressing a button on an ASP page?
View Replies
View Related
how to run a local Batch file from an asp page by simply pressing a button on the page?
View Replies
View Related
I have a batch file that needs to execute every day and I need to run it in a silent/invisible mode. I looked up on the Internet and found this command: shell("batchfilename.bat").
Upon failure, learned that it is a Visual Basic command and not VBScript command. I wonder if anyone knows how to run a batch file using vbscript that runs in invisible mode?
View Replies
View Related
I'm trying to call a batch file that I've built using the FileSystemObject and CreateObject("Wscript.Shell"), oShell.Run. in an asp script. Naturally, I can get the script to work from a command line but not from abrowser. The page does not throw an error but the oShell.Run. portion of the script doesn't run.
View Replies
View Related
is there any way of passing a javascript variable over to a asp variable so
i can write it to my database.
View Replies
View Related
I keep getting the BOF and EOF error message. My code is testing for entries within the database only from the current. If an entry of the current day doesnt exsist VBScript will spit the EOF /BOF error. I can i get pass this and still display my form as I want to. Here is my code:
View Replies
View Related
i used following code:
<%
set wshell = server.createobject("WScript.shell")
wshell.run "E:aaa.bat"
set wshell = nothing
response.write("worked")
%>
It does not show any error message and gives the output "worked"
I have installed .dll files for wsscript
Is there any other way to call batch file from aan asp page .
View Replies
View Related
This seem to be a simple question, but I'm having no luck with Google
keywords...
I have an some ASP in which I open a recordset via a connection to a MSSQL
database. I don't want to keep the database connection open while I'm
processing the data from the resulting recordset.
Is there a method that I can use to copy the recordset into an array
(collection, etc), the close my DB connnection and finally process the data
I copied from the recordset?
View Replies
View Related
I want to use vbscript to run a script multiple times and save its results to a text file. I have practically wrote this script before but only using a sql command wrote in to the script. However, this is a lengthy sql file so can not be directly entered in to the vbs script,s o I would like to run it using sqlcmd.
"SQLCMD -S "&WScript.Arguments(0)&" -i "&WScript.Arguments(1)
I have tried Googling this problem but found very little information about it. Any discussions online that I have found show no code and assume you already know how to do it.
I have found this so far:
Set objShell = CreateObject("WScript.Shell")
Set objScriptExec = objShell.Exec("sqlcmd -S "&WScript.Arguments(0)&" -i "&WScript.Arguments(1))
But how do I get hold of the results in to some kind of variable?
View Replies
View Related
Is there a command in asp to truncate a decimal? Currently I've got a number that's coming out with up to about 12 decimal places based on input fom the user and I'd like to force it to just display up to two decimal places. Is that possible?
View Replies
View Related
I ve a problem regarding data truncation....i m building a query in asp and trying to retrieve some data from that but the data in one of the fields that i m selecting is getting truncated after 255 characters though i ve set that field to memo in the table..
View Replies
View Related
This question has to do with MS file search but it is happening only with
..asp pages, so I though someone programming with .asp pages has experienced
the same situation.
I'm trying to find .asp pages with a certain table name (i.e.
"renewalInfo" )
When I ran the search I get no results. I know that I have that string in a
couple of pages. My file system search engine is working fine with other
file types, like Word documents, Excel spreadsheets, etc.
I tried typing the string outside the <% %> tags and when I do the search I
get the file results, so it seems like if the search engine in my file
system was not searching inside the <%%> tags. Code:
View Replies
View Related
I've got a form that uploads to a database. I was just testing that the max number of characters works. I have the field as varchar(100) and the maxlength as 100. When entering 100 characters I get the following error: (I even get the same error for 40 characters). Code:
View Replies
View Related
I am trying to make a variable appear in an SQl but am not sure how. Here is the sample code:
View Replies
View Related
i try to passing variable using get method in a url.
this is my example url
headertext="PE&CCA"
<a href="addsection.asp?uid=<%=uid%>&sublvl=<%=sublvl%>&headertext=<%=headertext%>">add</a>
i did print out teh variable headertext at addsection.asp, what i get is from the variable headertext is PE, so what shd i out in the url to get PE&CCA in my addsection page?
View Replies
View Related
I have a PHP page with a form which captures some information about a user before then redirecting the user to a ASP driven website. Thing is, there is obviously nothing to stop the user from simply noting the URL of the site they have been redirected to, and then going direct to the site everytime after.
Is there a way I can make the homepage of the ASP page only open, if it has been passed a hidden variable (by _POST). I could probably do this if the referral site was in PHP, but I have no experience of ASP. I assume i will need to input a few lines of code at the beginning of the ASP homepage which look for the POST variable and only open the site if it has been passed from the PHP page?
View Replies
View Related
I'm building a site with news headlines on my index.asp page. I want these headlines to link to a file called story.asp. This page would contain the entire article. The data is coming out of Access.
Am I supposed to use a querystring to pass the storyID from the headlines on the index.asp to story.asp? Is there other/easier ways to this? I want to be clear in the direction I'm heading.
View Replies
View Related
Is it possible to pass the "text content" in a table to a variable.. here's my code
<table border="1" width="443" id="table1">
<tr>
<td><%response.write vFieldOperator%></td>
</tr>
</table>
you see i want to pass the content in that particular table to a variable..
View Replies
View Related
I am pulling info from a recordset and all the information is correct as I have tested it in Analyzer.
The recordset returns info inside a table. From that table, I select a few options then submit the form. During the submit it passes 6 parameter. Up to this point, everything is correct. My problem is that my last parameter is passing the ID and not the Manufacturer Name. Code:
View Replies
View Related
Does anyone know how you would pass a variable back to the classic side from the ASP.net side? I pass a variable to .net, but for the life of me I cant seem to figure out the way to reverse it from .net to classic. Below shows where my variables are stored on the .net side from classic ASP.
Code:
Dim BgDate = Request.Form.GetValues("BeginDate")(0)
Session("BeginDate") = BgDate
Dim EdDate = Request.Form.GetValues("EndDate")(0)
Session("EndDate") = EdDate
View Replies
View Related
i have a problem when i'm passing a parameter into my function, it gives me an error saying invalid column ts Code:
View Replies
View Related
I have a form that you enter in a file path i.e c:folder1
you then click search and the application will search for that folder and check if it exists if so it will return a list of files in that folder. you are alowed to select what files you want to copie and then enter in the folder you want to copie them to.
here is my issues: i enter in my folder to search on and it is good I get a list of files in that folder I am also given the the folder path at the top of my table. in the code I have also created a hidden field so that when I click on my copy button my from folder path is sent over to that I can us it in my objFile.CopyFile.
NOW Here is where I go *WTF* at the top of my page I am printing out my folder path vartiable and it is right. however once i press that copy button the folder name gets cut off at the space i.e E:flkfkdlsdkklfile2 inforil....
so how do I fix this here is my code I have tryed to highlight the partst pertaing to this issue. Code:
View Replies
View Related
Im trying to pass the 'month' variable which is a session variable from one page to another. It manage to appear on the other page in a textbox but when I try to pass it to the recordset, it fails. Can I know why?? This is the page which I'm passing the variable to. Code:
View Replies
View Related
im trying to learn how to pass a variable taken from a database and write it into an xsl stylesheet. And ive found some info regarding this but its too advanced for me to understand. Could anyone explain it to me in newbie terms?
View Replies
View Related
What I have is an ASP page that starts off with multiple ways to access a project list and other pages via mysql queries. One of those is a button with the following
<form name="ProjectsActive" method="post" action="P_ProjSort.asp?ActiveSort=1&MySort=1">
From this button I'm wanting to pass a variable to acknowledge that it is ONLY wanting ACTIVE projects and also what was originally already there which is the MySort for sorting by different columns. The next page has the following I cut out some irrelevant stuff. Code:
View Replies
View Related
Can someone tell me if they see an error in my SQL statement? I'm passing the TEAMID var into this page. I know that works because I tested it.
ERROR:
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/league/teams/team.asp, line 13
<%@ language=vbscript%>
<!--#include virtual="/includes/common.asp"-->
<% Dim teamID %>
<% teamID = Request.QueryString("TeamID") %>
<% Set rs = Conn.Execute("SELECT * FROM tblTeams WHERE TeamID = " & teamID )%>
View Replies
View Related
I have a session variable 'Status' that I created in page1.asp in my website. After creating this session variable, page1.asp will redirect to page2.asp and will display 'Status' value. This works in both IE and Netscape.
A problem starts when a page (redirect.php) from another website (which belongs to a client) tries to call page1.asp. Using IE, page1.asp can't pass 'Status' value to page2.asp. However, in Netscape, page2.asp can display 'Status' value.
I don't think my code in page1.asp is wrong because it works if I type in the url to page1.asp directly in IE. The client's website runs on Linux. Anyone know if this is the cause for this problem? Anybody know how to solve this problem?
View Replies
View Related
i am trying to pass a variable to another page using a button.this is the code i have
<form action="G_Reply.asp?Title="<%=rsUser("Title")%>" method="post">
<button name="add" type="submit">
<img src="Pictures/G_Chat.png" width="150" height="20"></button>
</form>
Even though it does not work ,it does pass the variable when using as hyperlink like :
<% response.write ("<a href=G_Reply.asp?Title="&rsUser("Title")&"> Post Reply </a>")%>
(rsUser is my recordset and ("Title") is the field in the database. )
View Replies
View Related