Publishing to a website - subdirectory

What kind of upload we talking here? Do you upload it manually or use one of ASPRunnerPro built-in upload features?

I'm not sure. I think with GoDaddy, you have to use their upload FTP program. Or I could maybe use ASPR's built-in feature (FTP) or I may use Filezilla and upload with that.
I don't know if ASPR's files will point to the subdirectory like it does on my localhost. On my local host, it is

http://localhost/TBA/login.asp.
When I upload the SQL database, it will be different than my local machine's SQL Server. Will I have to change the connection in my Project then? I don't know how ASPR works with publishing. I notice if I use your DEMO account upload, I don't have to change the SQL connection and the subdirectory is there in the URL.
I just tried to upload the project to the demo account but got an error on a view. "Unable to create script for vw_LUTime" and other views.

It totally confuses me. Why don't you just upload it to your website using any upload method you like and if meet any specific issue - ask more specific question.
I regards to a different SQL Server connection - use 'Server connections' feature on 'Output directory' screen.

Ok, will wait until I do an upload to their site and PRAY it works!
Meanwhile, I can't upload to the demo account. "Unable to create script for ....error executing query....sp_helptext vw_LuTime....There is no text for object...."
I ran the script on SQL itself and it worked: sp_helptext vw_LuTime
Is there something corrupt in ASPR, where it's creating the scripts/file?

I guess you have some views that rely on SQL Server tables that do not belong to your project. In this case demo account upload won't work for you.

I believe I can give you the 100% authoritative answer - if you are connecting to SQL server or MySQL and aren't uploading a database.
I am using Godaddy to host SQL and ASP. I also publish my ASPRunner Webs straight to my hosting, and I have two separate webs running.
Go to Godaddy Web Hosting panel and create a subdirectory of your main web with their IIS Manager. It takes about 5 mins to go live.
In your Godaddy FTP credentials make sure you have at least an admin user. Note the username and password.
In ASPRunner go to the Publish tab and set your publish details. If your website is lottsacontent.com then that will be the hostname you need. Add your ftp username and password. You can then Browse to the directory to upload to. You should see a tree structure and can then select your sub-folder. That's all - except, I go straight to SQL and don't have a database to upload. I can't tell you how to get that working or where to put it. I assume that you would look at your output folder and note any sub-folder with the database in it and then create that as a sub-folder using Godaddy. I guess you browse for that on the Publish page too.
All The Best!