Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: anitalulu
  • Order by date
  1. anitalulu

    Get Conditional Statement in SQL

    I have use a table to store the conditional Statement as follow. CommissionTable CommissionRate ConditionalStatement 0.03 Sales < 50 0.05 Sales >= 50 And Sales < 80 0.06 Sales >= 80 And Sales < 100 0.07 Sales >= 100 And Sales < 120 0.08...
  2. anitalulu

    how to create a dynamic object?

    I want to create a dynamic object. When the user chooses a web service in a drop down list, the aspx will search the corresponding WSOjbect in the SQL server. e.g. the WSOjbect = TravelAssociationServicesUK Can I create a dynamic object as follow? Dim TravelAssociationWS As New...
  3. anitalulu

    Cannot use back Session variable outside of ascx

    Here is what I write in Login.ascx <script runat=server> Sub btnLogin_Click(s As Object, e As EventArgs) Dim member As New Member() member = member.login(txtUserName.Text,txtPassword.Text) if member.MemberID = 0 then lblLoginMsg.Text = "Login is invalid! Try again." else...
  4. anitalulu

    Cannot use back Session variable outside of ascx

    Hi I am a beginner of ASP.NET. I have created a Login.ascx which is a login layout and check the authentication. After the user can pass his username and password, I will use a session to store an member object. However, I cannot call back the member object session outside of this login...
  5. anitalulu

    Insert into database by upload an excel file with chinese charaters

    How to upload an excel file with chinese charaters into the database? I have set the datasource to the excel and select its content. However, all the chinese characters become strange words. Any suggestion?
  6. anitalulu

    How can I set the cold fusion value in javascript?

    I want to use a javascript's comfirm function to ask the user whether to overwrite the file during upload. The code as follow ---------------------- <script language= &quot;JavaScript&quot;> if (confirm(&quot;The file already exists. Are you sure you want to overwrite it?&quot;)) {...
  7. anitalulu

    how to write a stored procedure when a varchar variable is passed?

    I want to write the following Stored Procedure: --------------------------------------------------------------------------- CREATE procedure sp_GetFirstNode (@id int, @permission_id varchar(1000)) as begin select top 1 * into #temp from InfoTypeMaster where parent = @id order by seq while...
  8. anitalulu

    How to store Chinese character in SQL7?Urgent!

    Thanks your suggestion. Can you tell me how to change collation set?
  9. anitalulu

    How to store Chinese character in SQL7?Urgent!

    I cannot insert chinese character into SQL. Any suggestion?
  10. anitalulu

    Block a page if there is more than a user to access

    Thanks a lot.
  11. anitalulu

    Block a page if there is more than a user to access

    I want to block a cfm page if a user has already loaded that cfm page. Other users cannot be acccess that page. <!--- block the following code if more than one user to access ---> <cfform name = &quot;form1&quot; action=&quot;#self#?fuseaction=#fusebox.XFA.UploadHomepage#&quot...
  12. anitalulu

    how to improve the performance?

    Thank you very much. Your explaination is very clear. I will use structure to store the permission.
  13. anitalulu

    how to improve the performance?

    There are 2 arrays. arrPermissionDeny is to store the function id which is denied to the user. arrPermissionAccess is to store the function id which is allowed to the user. After the following programming has been run, a final permission access is expected. The logic of the programming is ok...
  14. anitalulu

    Using Order by / Group by?

    Hi, I want to order by the sequence of each id to display. My table structure is: id Name seq --------------------------------- 1 abc@yahoo.com 3 1 Cheung 2 1 Anita 1 2 def@yahoo.com 3 2 Leung...
  15. anitalulu

    cold fusion communicates with asp

    You are right. I can set the cookies for both CFM and ASP. However, how can I delete the cookies in CFM and ASP?
  16. anitalulu

    How to decrypt / encrypt in the SQL server?

    I have a &quot;registration&quot; table which stores username and password. I want to encrypt the username and password when retrieving them. Any suggestion?
  17. anitalulu

    cold fusion communicates with asp

    I can't put the variable into the URL. Because it is the username and password. Any suggestion?
  18. anitalulu

    cold fusion communicates with asp

    does anybody know how to communicate with asp page when i using cold fusion page? I want to pass some variables in cold fusion to asp page. Can I do this?

Part and Inventory Search

Back
Top