Search results for query: *

Ok.....I went and looked at the data in the db - seems some of these fields have leading spaces before the actual first name so the data looks like this: Adam Berny Charles Alexander Bobby Cheryl So it is sorting correctly - the spaces are just throwing everything off...I tried to...

Hello everyone, I have a datagrid that should be sorting two particular columns when the header is clicked. Well - one column is sorting fine - the other sorts fine up until the end and is out of order - but only when you get to the end of the list. This is my code Private Function...

So am I doing something for that to happen? It seems to happen after a week or so of constant uploading to my hosting account. I don't have access to the server since I am on a shared hosting plan. Is the 403.1 error related to the execution of a script and not just some actual .exe file? I...

Well, What are you using to build these pages? Visual Studio.NET? If so, you don't need the .vb files since when you "build" your project in VS.NET - it compiles everything you need in the .DLL file inside the Bin folder of your web Application. An easy way to get your project on the web is...

Hello everyone, I have an ongoing issue with my hosting company and can't seem to find a solution so I thought I would run it by you guys to see if I am doing something wrong. I upload my site directly from Visual Studio.net via the "Copy Project" method using the FrontPage Web Access...

It works perfect - I didn't realize I could write it out like that - thanks.

Hello, I have two tables structured like so: (top are fields, bottom is data) TABLEA job_id,user 100,user1 102,user1 103,user2 101,user2 TABLEB job_id 100 101 102 103 Table A represents all the current jobs the user has Table B represents all the jobs available to the users User logs...

Hello guys/gals, I am trying to figure out how to get my site to require Internet Explorer for a certain page - but can't seem to get it right. I have tried something to the effect of: If Not Request.UserAgent = "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)"...

Hello, I have been trying to figure out how to abandon a selected session. I have a page that pulls up all the current people logged into the web application, along with their session id. Is there a way to abandon which ever session I have selected? Meaning, is there something I can do...

Pretty cool. Actually, really cool. I just read through it quickly and noticed many cool features that will make web application development much much easier and more powerful. For now, what I decided to do is just when a user logs in, have it create a table and insert the username in the...

Hello all, I have been learning about Sessions and it is pretty exciting. What I can't figure out how to do is - keep a record of "who is logged in" Let's say five people log into my webform. I want to have a separate page for an admin to log into and have the page display evey logged in...

Hello. I am trying to format my ValidationExpression to allow text to be entered these 4 ways only (note, 1 stands for any number and A stands for any letter) aa1111a aa 1111a 1111aa1111 1111 aa1111 Seperatley, the following works: ^[a-zA-Z]{2}\s*\d{4}[a-zA-Z]{1} validates: aa1111a or aa...

Kulrom, You have been a great help. Thank you so much for this. I was trying to use indexOf and that wasn't going anywhere...thank you again!

Well, it is like this: Lets say the database lists column "locations" the data is like so: AA America BB Africa CC Canada DD France if a user types in the search box, aaamerica - it will not find what I need. That is the purpose to add a "white space" in the third position. But if the...

It is a MDB given to us from class. The teach wants us to create this app that deals with the db and present it for our final. I can only assume it was a test to see if we could figure out the solution :) That is the only thing I can think of - is that he purposley set it to do that so my...

Man...that works perfect - and it look so simple. Thank you for that. The only thing I run into with it is that if I already have a space there - it puts another one. I thought about setting the max length of the textbox, but that wouldn't work - as there are cases when the text will be...

I have a textbox and a button. no matter what is entered in the textbox - I want a space to appear after the first two characters when the button is clicked. So it will happen like this: textbox = AA1111B - button clicked - textbox = AA 1111B I have tried, format(textbox.text, "##...

That works :) LTRIM(inv_equipment)

Forgive my ignorance... The inv_equipment field in the database contains two blank characters before the begining of the quipment number so in theory, I should have been searching for " XX 1111" instead of "XX 1111". This database is so large that it would take forever to eliminate those...

This is what I am trying to do: Dim MySQL AsString Dim MyCommand As OleDbCommand Dim MyReader As OleDbDataReader Dim MyConnection AsNew OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;data source= C:\gtc\eqpinv.mdb") MySQL = "SELECT * FROM equipmentinventory WHERE...