|
I'd like to retrieve a file from a field in a DB.
So I use the RecordSet.GetChunk to get the binary file.
It returns a variant (actually an array of Bytes) and I'd like to write this array to the disk.
How can I do this?
|
|
|
|
|
|
we have using frameset. It has left frame and right frame.
In the left frame Tree structure is loading from the activex dll(VB 6.0) and getting data from database(sqlserver) and build the hyperlink. It has node and subnode. If i click on node or subnode data will be populated into the right frame.
My problem is, if i adjust the framesize some positions and click on the node and subnode in the hyperlink the framesize should stay there only. Now everytime getting refreshing and maintaing the old position only.
Any one please give the solution urgently.
TIA
|
|
|
|
|
Is it possible to print the call-stack (e.g. upon an error) to the output?
E.g. cool would be:
<br />
Response.Write Err.Description<br />
Response.Write Err.CallStack<br />
|
|
|
|
|
creation of discussion board with asp with source code
|
|
|
|
|
http://www.trav-tech.com/SpeakIt.html
http://www.trav-tech.com/BetaTTS.html
This is the Source for the BetatTTS demo:
http://www.trav-tech.com/BetaTTS.htm
Any ?'s email Webmaster@Programming-Services.com
|
|
|
|
|
Hello,
I'm writing a JSCript Web page which has to display the content of a Database table in a ListView object.
I created the object, filled it with the values coming from the table in an asp page.
My problem is now to catch events from this ListView object in my JScript page.
The events I would like to catch are the OnItemActivate and the OnColumnClicked.
I'm using Visual Interdev in coordination with Visual J++, which allows me to see the WFC objects, where the listview is laying.
Is there anybody, who already caught events from a WFC object in a JScript page, who would be able to explain me how to catch any event?
Thanks a lot for any help...
|
|
|
|
|
I'm writing an ASP page using VBScript to insert data into a SQL table. After I execute the string I'm getting the error Incorrect syntax near ')'. The code where I declare the query string is as follows:
'------------------------------------------------------------------------
InsSicLog = "Insert leads (siclogin) values ("&SicCounter&")"
'------------------------------------------------------------------------
where siclogin is the column name in table named leads and SicCounter is a variable defined earlier in the code.
I know this is just a syntax problem, but I can't figure out what I am doing wrong. Any help would be greatly appreciated. Thanks!
|
|
|
|
|
If this is used inside an ASP page you can use the following insert statement. You need to first make sure you have the correct flags set for inserting records.
I'm not sure if siclogin or SicCounter are variables or actual strings you want to pass in, so I wrote It both ways.
"INSERT INTO SICLOGIN VALUES ('SicCounter')"
"INSERT INTO " + CStr(siclogin) + " VALUES ('" + SicCounter + "')"
Again be sure you have the correct flags set for inserting a record.
Good Luck hope this helps.
|
|
|
|
|
Just to add to what Rick has put - if SicCounter is a numeric value, and that the database has it set as a number (I believe Access has rather vague field types - for SQL server it would be an INTeger or DouBLe field [capitals represent short names]), then you don't (and shouldn't) use the apostrophes around the value. For example:
"INSERT INTO leads (siclogin) VALUES (" & SicCounger & ")"
will be apropriate if you are inserting a new record into the 'siclogin' field of the 'leads' table - the value inserted will be equal to 'SicCounter'.
Post back if you need anymore help
|
|
|
|
|
I'm trying to understand why when my html form has ENCTYPE="multipart/form-data" declared. I am unable to retrieve the collection through the IRequest Interface.
Heres what I'm trying to do:
IRequestDictionary * pDict;
IRequest.get__Form(&pDict);
now when I call
pDict->Count(&iCount)
I get a big fat zero even though my form contains 3 objects.
If I take out the ENCTYPE="multipart/form-data" then it works just fine. You may say then just take it out stupid, but I would like send files from my client to the server. Any help in understanding why this doesn't work would be appreciated. Thanks!!
|
|
|
|
|
I want to use dynamic file name in #include directive like this
dim name
name = "test.htm"
<!--- #include file = name --->
Please help me in doing this.
Thanks!
|
|
|
|
|
In looking at your problem I think this may work.
<%
dim name
name = "test.htm"
Response.write("")
%>
|
|
|
|
|
open your file using FileSystemObjects, read all text from the file and do like
a = obj.readall
response.write a
i think it should work
Ahmad Billah
|
|
|
|
|
Hi,
Hi where Can I download ASP Compiler?
Please provide me suitable URL.
Thank you,
Rakesh
|
|
|
|
|
You don't need any asp compiler,
ASP isn't a language, it's a way to run serverside-script.
(Active Server Pages.)
You'll just need an usual texteditor and PWS or IIS to +begin develop ASP
|
|
|
|
|
Sorry for confusion!!
I am just talking about the VBScript compiler that Hide code (like changing into binary to protect the source code to be pirated by others)
I heard about Microsoft Script Encoder includes command line program called screnc but didn't find in my PWS awa IIS 3.x later too.
I will be very thankfu to you if you provide me any URL.
Thanks
|
|
|
|
|
I don't understand how in ASP empty strings are handled. I check if if a field in a resultset has indeed a value. If not, I'll add "" to the dictionary. Afterwards, I want to use the items in the dictonary but there's not "" in some fields, but the Object-type null! So I have to test on it and set the string to "" myself
// oRs is a ADODB.ResultSet
// d is a Scripting.Dictionary
e = new Enumerator(oRs.Fields);
for (;!e.atEnd();e.moveNext()) {
i= e.item();
if (typeof(i.value) != "unknown")
else d.add(i.name, "");
}
arr = (new VBArray(d.Keys())).toArray
for (i in arr) {
q1= d(arr[i]);
if (q1 == null) q1= "";
q= Server.HTMLEncode(q1);
}
Can anyone help me?
|
|
|
|
|
This is a database-issue, not an ASP-one. NULL-values in a database (even in text-fields) are not the same as empty strings!
In MS Access, I think there is an option of allowing a text-field to contain empty values (e.g. ""). But its always a good idea to check for NULL.
In VBScript: if IsNull(q1) then, in JScript as you did, I think (never used JScript in ASP myself).
|
|
|
|
|
I have an html-'template' with a form in it.
When it is submitted, the entries will add to an ADODB.COMMAND to update a record in a database.
I am having difficulties with empty form-entries: ADODB.COMMAND.Execute() is complaining about 'cannot use 0-length strings'. A simple workaround like if (s == "") s= " "; does the trick, but that's ugly: I don't want random spaces to appear in my database!
Anyone?
|
|
|
|
|
I'm not positive what your trying to do here but it seems that if you have a chance of a data being an empty string. And this is valid for your application then you should allow zero length fields in your database.
Good Luck!!
|
|
|
|
|
|
hi,
I need to authenticate users to a web site but the problem is I dont want to use session variables, because the site is to be hosted on a web farm running multiple servers and pages can be served from any server. I am trying to figure out how we can authenticate users and how users can be identified after login, in this setup.
any ideas will be appreciated
thanks for your time
karthik
|
|
|
|
|
Hi Karthik,
I have recently read this article at ASPtoday. It should be the solution you are looking for
http://www.asptoday.com/articles/20000704.htm
Regards, Tom.
|
|
|
|
|
If I have a database that has a whole lot of files in it that are incoded in BASE64. Is there some way I can return them straight to HTML so the browser knows to it is downloading a file....e.g.
I want to return the BLOB so that I am really returning an HTML page to the person will see www.xyz.com/download.asp and download.asp contains something like
Content-Type: application/octet-stream;
name="test.exe"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
filename="test.exe"
qANQR1DBwA4DXCexCm8KkTsQAv9wDCPX+7o05gnUq0hH5nEPofQ5a8bpnx82OqvmgKCd65fBIbz9
8GjkmslBrB9N+LU7G0RMbhIZFYHcoqOMW1Jje64UR/6TLQ/61Fw+v/j0bsPXU8/ACdb0tX9kNjR8
C/0C/0k7nBcylnZmMHrYXeuGfjAnLjyXMu08+wCCCf0IYn6COEZObwCXlESgOXfIITMq44QJno91
w4enDZ5t0X9KewUrcVh8hUq4WKsXGPRI0DV5YlJEuNAImlf+DvL4DrtI9cHCTgPZ0XOtEPSlchAM
AKIJh+R2vswfQheAla7fkLp1hqShCra1DkXTdU41EHfwf9EVmOs2d9ovLuFWnH8ukqh8BYNjXuxK
Rfo13mMXqRQBW5b0pKcVPONOcokD2mDaKiuYIbmwm6A+I9LUfAoxg9tj6IrF1LxL53Ysq3FMxqh0
OJKg5iYpBqnhCVgUon6p/Fn41onF9HVhbxZsdRTpIum9YjctoMGNb3DTclp9tX/cEFIGvhuOTZUR
6401S=
and then the browser will know to pop-up a download dialog.
|
|
|
|