Recent content by FengShui1998

Hello, I need to get a list of device ID's from Active Sync in Exchange using VBScript and Active Directory. I don't have Exchange permissions os I can't use thee Exchange powershell tool which would be real easy. But I believe this attribute is available in AD. msExchMobileAllowedDeviceIDs...

Hello, I need some ASP examples on how to prevent cross site request forgery or CSRF. Most of the examples I have seen are for ASP.NET, but alas, I am still on ASP Classic. Does anyone have any samples on how to implement tokens also? Thank you in advance. fengshui1998

Hello, I have an SQL query that returns alot of columns from several tables. In object result, I can access some columns such as PIN = objRs("PIN") or other column names. However when I try to access another column like phone = objRs("Phone") the ASP page blows up. In VbScript, I have no...

Hello, Does anyone have any examples on how to authenticate to a non-Active Directory LDAP server using VBscript? Thanks, fengshui1998

Hello, Does anyone have any vbscript samples on how to form a SOAP request and read the response back using username and password? Thanks for the help! fengshui1998

Hello, Does anyone have any vbscript samples on how to form a SOAP request and read the response back using username and password? Thanks for the help! fengshui1998

Hello, I have an ASP page that used to connect to an SQL database with an SQL login. For security purposes, they have disabled the SQL logins and now they are requiring a domain login. Now I can't run an query with the SQL login. Is there a way I can spoof a domain\username to the SQL database...

Hello, I have an SQL field called IMEI that contains data "01 353443 3444 555". Is there a way to input a search string "013534433444555" that eliminates the spaces in SQL query and finds the record "01 353443 3444 555"? Thanks ahead, fengshui1998

I understand that, but I want to exclude other devtypes like devtype=blackberry or devtype=windowsphone. Thanks.

Hello, I have a table with multiple entries for devices where the DEVTYPE = 'iPad' or DEVTYPE = 'iPhone' and each record has the OwnerID. An owner can have multiple records. I'd like to pull just the OwnerID whether they have and iPad or an iPhone. I am using DISTINCT however it's returning all...

Hello, Does anyone have any sample VBScripts on how to request a web service or WSDL using a username and password? Thanks ahead, fengshui1998

Hello, In Table A, I have a column called OwnerID that is unique. In Table B, I have multiple records of different OwnerIDs and purchases. I'd like to list the distinct OwnerID from Table B and match them with Table A. THanks ahead, fengshui1998

Is there a way to create the trigger for a certain RecordID?

gmmastros, Thanks for your reply. It seems that only displays a message. What keeps the record(s) from actually being deleted? Fengshui1998

Hello, I am doing an INSERT on a table that creates a RecordID. After the INSERT, I would like to prohibit anyone from deleting that record, but still be able to UPDATE it. Is there a way to DISABLE DELETE or something? Thanks ahead. Fengshui1998