I am struggling to find an encryption function that doesn't generate invalid characters like quotation marks, (").
The reason being is that I need to use the encryption in SQL query strings and these characters cause errors Code:
I have a problem with some japanese characters.
When the two Japanese characters ｰ and ｼﾞ are used in the window name
parameter of the window.open function, the expected new browser window does
not open. This needs to be tested on localised Japanese operating system.
The problem only happens on IE7 browsers (on all operating systems). IE6
works ok. Is this a known issue? Any suggestions for a possible solution?
When we send a mail using the code below,we do not get simplified chinese characters if they are present in the body but we get junk in the mail and we need to change the mails encoding to simplified chinese to see the Chinese characters.
'CDONTS object
set objMail = Server.CreateObject("CDONTS.NewMail")
objMail.MailFormat = 0
objMail.SetLocaleIDs(65001)
objMail.From = sFromEmail
objMail.To = sToEmail
objMail.Subject = sSubject
objMail.Body = sMessage
objMail.Send
set objMail = Nothing
i am trying to check a textbox if there is any invalid Characters like:
?/.>,<=+-_]}[{|~`! @#$%^&*()
i want to make sure that non of these are entered into a textbox before i insert that field into my database. what's the code.
The query works fine without ordering. But when I try to put ORDER BY that error message appears.
My query is working when it looks like that:
"Select TAB1.WCUST, TAB2.name, sum(TAB1.qty) AS SUMQty, sum(TAB1.wamt) AS SUMWamt from TAB1 LEFT JOIN TAB2 ON TAB1.WCUST=TAB2.name Where TAB1.WMNID=10 GROUP BY TAB1.WCUST, TAB2.name;"
But after I add ORDER:
"Select TAB1.WCUST, TAB2.name, sum(TAB1.qty) AS SUMQty, sum(TAB1.wamt) AS SUMWamt from TAB1 LEFT JOIN TAB2 ON TAB1.WCUST=TAB2.name Where TAB1.WMNID=10 GROUP BY TAB1.WCUST, TAB2.name ORDER BY sum(TAB1.wamt) DESC;" it gives me the error message:Invalid use of group function.
I tried to order the query by WAMT and it was OK.
I'd want to make a custom class that will generate breadcrumb navigation for my site via a recursive query, e.g. Home > Page1 > Subpage 1. I've structured my database with hierarchical parent/child relationships.
I'm using ASP VBScript, and I have a table structure similar to the following: Code:
I had came across an error known as "Bad Request (Invalid URL)" when i was trying to input chinese characters into MS SQL database using my asp written page. For your info, I'm currently working on Windows Server 2003 and running IIS 6 on this server.
Hereby i enclosed my asp request method tat i'm using
<%
sCategory = request.querystring("txtCategory")
....
%>
the txtCategory textbox contains chinese characters, and after that I'll insert the sCategory string value into MS SQL database.
how to correct the database insert issue with characters like ' and ,
I remember a while back I used a function to replace this, and that fixed the problem, but it was so long ago I have misplaced it and forgotton.
I am using CDONTS to send mail to the user from my ASP application.
However, the code doenst works all the time. I am able to get mails but
nothing happnes most of the time. The code works maybe once in 20 tries.
What could be the reason?
I have a query in ASP that does a select * from table
It doesnt retun all columns!
When i use objRS("columnname") I get blank. This only effects some colums and I fix it by using
select *,missingcolumn1,missingcolumn2 from table
i posted earlier, and the response seemed to be there is
another dll i need to use the cdonts object, i used it
fine for awhile on my old setup, i upgraded to 2k3 and it
errors up as if cdonts isnt an object. So is there a dll
i need to have to use the cdonts object in iis 6 or do i
need to rewrite my code to use cdo? (if so, please provide
asp 3 example on how to send an email with recepient,
sender, body and subject)
I wrote the code for Members of Register. and i use cookie in this code, My database is SQL server. SQL server dosent support the cookies in my codes i dont know why this cause but my codes are working without any cause .
View Replies View RelatedI have got a problem wit da FILESYSTEM in ASP coding. Before I use window 98 installing PWS. Everything works fine....
And now, I use Window XP professional ( Laplop ), everything is updated ( Service Pack, .NET component, ASP.net stuff...
All my ASP code with FileSystem which used to be properly ran cant be executed on my XP server.
There is no message error on da page, but the browser icon keeps spinning and da content is blank, it means u dont see anything happens. I wanna ensure dat all da code is right, cos it work properly with PSW and other servers. I even tested with a simple code, but It still doesnt work..... Code:
My ASP page contains the following VBScript code:
<%
zipCode = Request.Form("zip")
%> <br>zip: <%= zipCode %>, rf: <%= Request.Form("zip") %>
When I enter "abc" into the "zip" field on the form, I get the
following output:
zip: , rf: abc
Why doesn't the first statement assign the "abc" string to the
variable "zipCode"? What am I not seeing?
My friedn is using PWS on NT4 machine, its a local machine, whenever he directs to an .asp page, visual interdev starts.
How can we over ocme this.I had solved this problem long time ago. Now i dont remember. Also to install IIS4.0 do we need to install MTS? if yes, where can we get
it?
I'm using SQL Server and I decided to convert one of the fields from nvarchar to ntext. The transition in the manager was all right, but my ASP pages wouldn't display the ntext and there is no error message. I use Code:
<%=rs("Text")%>
to display the ntext...and there is nothing.
I have a database table with several records. Now I am filtering some data based on the "where" statement. If I run the query in analyzer then I get 20 rows. If I run the same query in asp and assign GetRows() to an array, then the array returns only 4. I am not sure if I am using the GetRows wrong. Here is a snipp of my code:
View Replies View RelatedI have one field char type data length 1.. It has data either 1 or 2 in all the field tht I have checked through enterprise manager.
I'm running query:
"select * from table" and fetching all the records and displaying...
It display all the data except data from this field..Doesnt display anything..
I had put Response.write rs("fieldname")
What could be the problem?
I want to encrypt the values that are passed as querystring and decrypt tha values in the result page in ASP.
View Replies View Relatedim looking to encrypt a string of numbers in ASP using javascript. Ive been looking up encryption using RSA that does this for text strings. Does anyone know if this can be done with a string of integers?
View Replies View RelatedIs there an encryption protocol that asp classic uses that asp.net also uses?The reason is, I need to allow users to automatically be logged on if they are logged onto the old asp site in the .net one.They are on the classic asp site, they click a link, first, some info is gathered then it is encrypted and placed in a query string.The .Net site gets the query string, decrypts it and takes it from there.
View Replies View RelatedI'm trying to find an encryption algorythme that is emplimented in asp and js so that I can encryp a password client side with the js and decrypt server side with the asp.
View Replies View RelatedWhat is equal function to PHP's md5() in ASP to encrypt strings?
View Replies View Relatedwhat I'm looking to do is encrypt a small portion of html code that is generated by my ASP page. I haven't had much luck finding any info to see if it can even be done though.
Does anyone know a way to encrypt html so its not as easily viewed by the source page code?
What will be the best way to encrypt/decrypt my code. I'm currently using a include file in my code, and want to encrypt this code page.
Will it be best to write a dll to do the encrpytion/decription and call this every time
I want to access the file or not.
How to display data in 128 bit or min or 64 bit encryption form.
View Replies View RelatedMy form accepts user name and password. I want to encrypt the password when I send it to the server. I think I can use windows advapi32.dll functions to encrypt and decrypt the data. Does anybody know if I can use this dll directly in my asp? Do I have to write customized dll which uses advapi32.dll and then use the customized dll in the asp?
View Replies View RelatedI would like to know what is the best to encrypt/decrypt info using ASP. I would like to encrypt some darta when recording it in an Access db and decrypt it when retrieving the data in question.
I guess that there are no built-in function so I was wondering if you would have a script that you would recommend. Or should I use a third party? It doesn't have to be very complex.
I am planning to provide the Pause/Resume while uploading files.Our site is using both java applet and activex to do this.The list of selected files will be stored in an encrypted file using SHA256(I have taken the code from:
[LINK]...
The user can Pause file uploading and can resume file uploading even without login to our site at any time (even after days/weeks).Since the list of files are stored on an encrypted file our site's client service program will upload the rest of files.I invite all to discuss about the security issues arise out of this solution and how secure is the above program using SHA256?
Is there any function in sql server to encrypt a column data? If not, then is it possible in ASP?
View Replies View RelatedI have developed a real estate software and I want to encypt few lines of ASP code so that it becomes difficult for a user to edit the code and change copyrights. Example:
<%
CONST txtUrl = "itHighway.co.uk"
CONST txtTitle = "Real Estate Software"
CONST txtDatabase = "MS Sql Server"
%>
How can I encrypt only first two constant variables?
"Cannot use Request.Form collection after calling BinaryRead"
I get this message cause I have a form that inputs two types of data: a file to upload and a field value to save in a datasource. The encryption is "multipart/form-data". The file is uploaded successfully, but, how can I invoque the fields of the "request.form" without getting this error?
I am currently working on a project where I need to encrypt the query string parameters to hide the details from the user. However, everywhere this parameters are used, I must encrypt on the calling page, and then decrypt on the page being called.
if there is a way to do this transparently so that I don't have to do these steps for all pages? I know this can be done using an HTTP module in .NET but is there a way to do this in classic ASP ?