Search:

Hi

The login page is in one project and the 4 areas or additional projects are accessible once the user logs in. There's only one log in page. I have the 4 projects in VS and on my HD these are...

Hi

I keep getting the above error whether I ran my asp.net solution from the IDE or publish it on IIS. I always Build before each one of these steps.

I have user controls inside web pages and...

Wow...OK. Very helpful.

I'll move the post.

I have a login page and main user page that are one project then the user on this main page can go to 4 different areas which are all separate projects in their own folders. Links on this page to...

Hi

I keep getting the above error whether I ran my asp.net solution from the IDE or publish it on IIS. I always Build before each one of these steps.

I have user controls inside web pages and...

Set MyRpt = New CRAXDRT.Report
Set MyRpt = crxApp.OpenReport(app.Path & "\MyRpt.rpt")

Set MyRptVSubreport = MyRpt.InvVoiceSubList.OpenSubreport

Bombs out on last line. But it could be any...

Hi

I am really stuck trying to do the above. I keep getting an error "object doesn't support this property or method" when I reference the modified report in my VB6 app. If I do not modify the RPT...

Here's what gives me that error I mentioned:

UPDATE A SET A.AggregatedMinutesOrCalls = B.AggregatedMinutesOrCalls, A.LastBilledDate = B.LastBilledDate, A.NextBillPeriod = B.NextBillPeriod FROM...

Thanks. Is this for SQL Server?

For Access and MySQL I get an error on the FROM in the UPDATE part.

Hi

We need to update a table from another one. The target table AdditItems has to be updated with values from another table called AutoCRCustInvMain. The table AutoCRCustInvMain has more than one...

Thanks. The problem was with the resizing control i use on my forms. Thanks.

ok, I'll test this some more then, with a blank project. Thanks.

I tried setting the width in the form activate, resize and gotfocus but the columns keep jumping

Hi

Has anyone noticed how if you set the decimal separator to be the comma in the windows regional settings, load an app that uses the vb6 listview, the columns jump all over the place if you...

Hi

The hosting cpy has just installed capicom but I still get the same error. Do u know if I have to build the interop from the actual same file as the one they used and if it has to be copied in...

Hi

The dll is capicom.dll.

Thanks to all for your excellent help.

Mike

Hi

I am trying to use a COM dll referenced from a vb.net project. Everything works fine when I reference the interop inside the IDE but when I publish the file in bin folder on my server I get:
...

I'm trying for the fields on an asp page to be read/grabbed by another page but this one is an aspx page. Both pages have exactly the same fields. I wanted to know how this can be done. Example:
...

i

Pradeep, just tried your sql but gives same incorrect results.

Hi

I think I've fixed it. Results are ok now:


SELECT DISTINCT TB.GroupName, SUM(TA.Customer_Call_Cost), COUNT(TA.ID)
FROM VoiceAutoCRCustomerInv AS TA INNER JOIN (select distinct groupname...

Thanks. It might work in other DBs than Access but in Access I get:

Syntax error missing operator in query expression 'count(distinct tb.id)'

Hi

I'm trying to select some rows but keep getting double the number of records because of duplicates for each record in table calltypes. Here's what I have:

SELECT DISTINCT TA.GroupName,...

Thanks, that worked very well.

Hi

I have a table with a price list name (ListRef) and with prices in it and need to retrieve all results and keep together records for each price list.

Here's the SQL:

SELECT * FROM...

protected void Page_Load(object sender, EventArgs e)
{
if (Session["is"] == null || Session["is"].ToString() != "1")
Response.Redirect("Default.aspx");

string...

protected void Page_Load(object sender, EventArgs e)
{
{
if (!Page.IsPostBack)
{
LoadCurrency();
}
}
}

It's used on this app:

http://www.dynasoft.net/billing/telefactura_crm/Dealer_Login.aspx

Once logged in, click on Register New Master dealer and you'll see a page with a currency drop down.
...

Sorry. Here goes.


strquery = "UPDATE Distributors set Currncy = '" + dropCurrency.SelectedItem.Text + "'"
Cmd = new OdbcCommand(strquery, con);
Cmd.ExecuteNonQuery();
...

"The function is loaded in page load once only when the page loads for the 1st time."

Here's the code in the aspx page:

<tr>
<td class = "style1">Currency:</td>
<td style = "width:...

Hi

I have the following code that loads currencies from file and a default one from db. The user then clicks the menu, but I keep getting the first entry in dropCurrency.SelectedItem.Text instead...

Sorry guys, the code had been written by someone else and the quotes were indeed added by the VB code. Thanks to everyone.

I get errors.

Invalid text or symbol.
Error in list of function arguments: '""' not recognized.
Unable to parse query text.

I have these sql server queries: one is a view and the other a udf.

It's a udf function called from a view like so:

View:

SELECT Results
FROM dbo.udf_MyBillingFunction()

I...

Thanks. I tried on Access and MS SQL and it works fine. MySQL does not though. Thanks anyway.

Hi

Saw your query does not work under mysql. I get the following error:

You can't specify target table 'story_category' for update in FROM clause.

story_category is the table name in colHdg....

And sorry again. It worked very well. I had missed a bit of your sql out. Thanks for your help with this.

I get an error: Operation must use an updateable query. Any ideas?

Sorry, will try this.

I don't see how what you wrote is different to what I posted. I am looking for a single update query to replace the select and update I posted. Thanks.

Hi

I have the code below but have problems trying to convert it into one clean update query. Any help would be greatly appreciated. Thanks.



Set MyTable = New ADODB.Recordset
strSQL...