Search results for query: *

something like this: Status = '" & Replace(request("Status"),"'","") & "' Or Status = " & request("Status") & " -VJ

Thanks for your insight guys... but i was wondering what could be the reason for breaching the license or using ONLY the products available from cognos... i am sure that we have read permissions to read the data from the voyager billing system and we are doing reports to see this data using a...

Hi Tom, We have a Snap Server ( i think it is basically a hard disk with no operating system ) with data on it... What would be the best way to connect and retrieve data from it.. Do i need to export the data to some other database system(like for ex: SQL Server) before retrieving the data or...

Thanks Tom, Thank you for your suggestions which pointed me in the right direction to begin with...i will be right on this task and will post my progress... -VJ

Thanks for your suggestion Tom...i am good and comfortable with ASP,ASP.Net,Javascript. I will try to work with these technologies to begin with. But i have one last question for you... What actually should i ask the Voyager Billing system vendor... //How can i connect to your system and...

The thing i am confused is with what programming/scripting language i should consider writing these interfaces... intially i thought using ASP... but i am not sure now... -VJ

Thanks Tom... it looks like a mess to me also. So if i start considering to write an interface layer(as you mentioned) for the data on voyager how would i go about doing that... and any other suggestions about writing the interfaces as you suggested... i think i need a starting point...i am...

Hi Guys, we have our company data on Voyager Billing System software (by BCGI) and we use Impromptu Cognos to access this data and make reports out of it... So when cognos impromptu can connect and access the data from the tables in the Voyager...i was wondering how to connect to the tables on...

Thanks for the information Tom... Is there any other way i can achieve my task...i mean i want to give a nice front end using which the users can get the reports they want directly on the intranet.... Presently they send me the information with the constraints ( for eg: list of customers who...

I think its using its own proprietary DB engine... I just wanted to create some nice ASP front-ends (like search functionality etc..) and access this data from Voyager... Thanks -VJ

hi Guys, May be i should clarify more on what i was wondering can be done or not. we have our company data on Voyager Billing System software (by BCGI) and we use Impromptu Cognos to access this data and make reports out of it... So when cognos impromptu can connect and access the data from...

Hi Guys, Does anyone know how to connect to Voyager Billing system using ASP. Can anybody suggest me how the connection string looks like... Thanks in advance. -VJ

Ok then i guess the second query is working fine but not getting any records...so change your code to something like this: strsql4 = "SELECT * FROM [PC Software] LEFT JOIN ( ([PC Hardware] ON [PC Software].pcid = [PC Hardware].id) LEFT JOIN (Software ON [PC Software].softwareid = Software.id...

That error means that you are getting an empty recordset... can you post some of your data and the kind of result you are looking for... may be we can try changing the query -VJ

Try this: strsql4 = "SELECT * FROM [PC Software] LEFT JOIN ( ([PC Hardware] ON [PC Software].pcid = [PC Hardware].id) LEFT JOIN (Software ON [PC Software].softwareid = Software.id ) ) WHERE [PC Hardware].id = " & ID & " ORDER BY AppMan, AppName, AppVer;" -VJ

Try this: strsql4 = "SELECT * FROM [PC Software] LEFT JOIN ([PC Hardware] ON [PC Software].pcid = [PC Hardware].id LEFT JOIN Software ON [PC Software].softwareid = Software.id ) WHERE [PC Hardware].id = " & ID & " ORDER BY AppMan, AppName, AppVer;" observe the parentheses -VJ

try using SERVER.HTMLENCODE(rs("'MEM_PIC'")) -VJ

faq333-3656 faq333-1498 faq333-1507 -VJ

Select categoryid, product,txtcategory from table1 inner join table2 ON categoryid.table1=Id.table2 -VJ

But where do you want to go...do you want to be on the same page... it can be easily done using Javascript... provide more details on what actually you want to do -VJ