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.

...question is - how the heck to I do that? I tried something like this: (say the MyReader is associated with the first Select statement select * from TABLEA string.format("select * from TABLEB where job_id<>'{0}'", MyReader("job_id")) This doesn't work though - can anyone help me out...

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...

...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 1111a ^d{4}\s*[a-zA-Z]d{4} validates: 1111aa1111 or 1111 aa1111 Is it possible to validate both ways...

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)

...to eliminate those extra spaces, so I came up with this and it works - unless somebody has a different way (I know using the LIKE is sort of slow). MySQL = String.Format("SELECT * FROM equipmentinventory WHERE inv_location='{0}' AND inv_equipment like '%{1}'", txtEntity.Text, txtEquipment.Text)

...As OleDbDataReader Dim MyConnection AsNew OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;data source= C:\gtc\eqpinv.mdb") MySQL = "SELECT * FROM equipmentinventory WHERE inv_location='950102' AND inv_equipment='AO 3333C'" MyCommand = New OleDbCommand(MySQL, MyConnection)...